...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Overview
...
Use the stream attributes properties tab to specify the characteristics of the the data in a table column.
This setting is not available from the repository browser. It opens from:
- the Stream properties → Attributes table
- other attribute lists.
Stream Attribute Properties
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Basic Settings
| Field | Description | |
|---|---|---|
| Name | Enter the name of the attribute. | |
| Type | Select the attribute type for the data.
| |
Length | This field is available when Type is String. Enter the maximum number of characters allowed in text data. For unlimited text strings, set a Type of Bigstring. | |
| Precision | This field is available when Type is Integer. Enter the maximum number of digits allowed in whole numbers. | |
| Significant Figures | This field is available when Type is Decimal. Enter the maximum number of total digits for decimal numbers. | For example, to specify numbers must have two digits before and after the decimal point, such as 12.34, enter: |
Significant Figures Decimal |
Places | |
| Decimal Places | This field is available when Type is Decimal. Enter the maximum number of digits allowed after the decimal point. |
This must be less than the number of significant figures. | ||||||||||||||||||
| Local | In most cases leave this option
| |||||||||||||||||
| Order | The order of the attributes in the stream. Stream attribute expressions are evaluated in this order. This is important when you need to use the results of a calculation in another attribute:
In the attribute list, the attribute that calculates the result must come before the attribute that requires the result. | |||||||||||||||||
| Expression | The expression used to generate the attribute value. This is written as a PhixFlow Expression. It must evaluate to a single value, of the type specified in the Type field. | |||||||||||||||||
Advanced
| Field | Description | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Indexed | Tick this option if this field should be indexed
To improve performance, index an attribute when the stream has a large data set and an output pipe from the stream uses this attribute to:
| |||||||||||
| Filter conditions are case-independent by default | If ticked, new
| |||||||||||
| Key | For
to specify that this field will be used as a key value.
| |||||||||||
| Cache Key | If a cache key is set, Enter an expression to be evaluated for each stream item (data record) in the stream. The expression can
Once calculated, the cache key value persists throughout thesubsequent stream calculation, rather than being created from scratch for each stream item as normal. This allows you to keep track of the calculation as it progresses. The cache key is an expression that is evaluated for each stream item, and of course it can use the existing value of the attribute, in other words, to value it had in the previous stream item processed in the stream calculation. This allows expressions to use theThis means you can use a "persistent" attribute value on subsequent stream items. The expression provided in the Cache Key is evaluated for each stream item so that this "persistent" attribute can refer to multiple value keyed on the "Cache Key".in other expressions. CHECK THIS |
Access Permissions
| Field | Description |
|---|---|
| All Users Can View Data | to do |
| User Groups | to do |
| Anchor | ||||
|---|---|---|---|---|
|
...
Which fields can have "null"?
String
Apply a string type to sequences of characters (i.e., letters, numerals, symbols and punctuation marks). By default string attribute types have a fixed length of how long?
do we need to tell users about any information-loss if data that is naturally a different type gets loaded as a string?
Anchor Bigstring Bigstring
Bigstring
| Bigstring | |
| Bigstring |
...
The maximum bigstring size can be configured in System Configuration → System Tuning → Maximum Bigstring Size.
Integer
Apply an integer type to whole numbers (not a fractions or decimals) that can be positive, negative, or zero.
What happens if you attempt to load a float or decimal number into an integer attribute?
...