...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
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
...
Basic Settings
...
- String for text strings
- Bigstring for text
- Integer for text
- Float for text
- Decimal for text
- Date for text
- Datetime for text
- Graphic for text
- TrueFalse for text
...
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.
...
Use the attributes properties tab to specify the characteristics of the data in a table column. You can open attribute properties from:
- the repository. Attributes are listed under their stream
- the Stream properties → Attributes table
- other attribute lists.
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. By default strings are 50 characters long. Optionally specify a different string length of between 1 and 4000. For strings longer than 4000 characters, set a Type of Bigstring. | |||||||||||||||||
Precision | This field is available when Type is Integer. Enter the maximum number of digits allowed in whole numbers. By default, integers are 10 digits long. Optionally specify a different integer precision of between 1 digit and 38 digits. | |||||||||||||||||
Significant Figures | This field is available when Type is Decimal. Enter the maximum number of total digits for decimal numbers. By default decimals have 10 significant figures. |
| ||||||||||||||||
Decimal Places | This field is available when Type is | IntegerDecimal. 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. |
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
To specify numbers must have two digits before and after the decimal point, such as 12.34, enter: Significant Figures 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.
after the decimal point. By default, decimals have 2 decimal places.
This must be less than the number of significant figures.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
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:
- either in its expression
- or in a $ variable.
In the attribute list, the attribute that calculates the result must come before the attribute that requires the result.
Advanced
Field | Description | ||||
---|---|---|---|---|---|
Indexed |
|
|
|
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:
- either in its expression
- or in a $ variable
In the attribute list, the attribute that calculates the result must come before the attribute that requires the result.
Advanced
Field | Description | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
| to index this attribute in the underlying database.to set new filter conditions on this attribute to be case-insensitive by default. The filter window → Ignore Case check box inherits this setting; see Filters on Data Views. For case-insensitive filters, there is no difference if the attribute is also indexed.
| |||||||||||||||||||||
Key |
| to set new filter conditions on this attribute to be case-insensitive by default. The filter window → Ignore Case check box inherits this setting; see Filters on Data Views. For case-insensitive filters, there is no difference if the attribute is also indexed.
Note |
---|
This option affects the behaviour of filters for PhixFlow instances running on Oracle or MariaDB (MySQL) databases. For PhixFlow instances running on a SQL Server database, filters are always case-independent. |
for in-memory streams, to specify that this field will be used as a key value.
Anchor | ||||
---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Enter an expression to be evaluated for each stream item (data record) in the stream. The expression can:
- either use the value of this attribute
- or calculate a different value
Once calculated, the cache key value persists throughout subsequent 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.
This means you can use a "persistent" attribute value in other expressions.
Access Permissions
This means you can use a "persistent" attribute value in other expressions. |
Access Permissions
For details about how to control access to a stream attribute, see Common Properties → Access Permissions.
Anchor | ||||
---|---|---|---|---|
|
...
All stream attributes have a data type. When loading data from a source, such as a file or database, PhixFlow applies the data type from the source. If there is no data type specified, PhixFlow applies the default type of string.
You can change the type of a stream attribute before the data has been loaded into the stream.
Once the stream has contains data, the attribute type can only be changed if the database allows the change. this is database dependent. You will see an error if your change is not allowed. If the stream has no data then any change in attribute type is possibleyou may be able to change the data type, depending on the database on which PhixFlow runs. PhixFlow reports an error if you are not permitted to change the data type. In this case you can rollback all stream sets so that the stream no longer contains data; see Rollback.
String
Apply a string type to sequences of characters, such as letters, numerals, symbols and punctuation marks. By default string attribute types have a default length of 50. However you can configure a minimum length of 1 and a maximum length of 4000Specify a different string length in Basic Settings → Length.
AnchorBigstring Bigstring
Bigstring
Bigstring | |
Bigstring |
Apply a bigstring type to text strings over 4000 characters long. Bigstring is a different data type to string and has some restrictions on filtering, sorting and aggregation.For string. For PhixFlow instances that use an Oracle database, bigstrings:
- cannot be sorted or aggregated
...
- can only be filtered with the conditions:
(not) contains
is (not) null
(not) starts with
(not) ends with
.
The maximum bigstring size can be configured in PhixFlow administrator can configure the length of a bigstring using 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. The number of digits in an integer indicates its precision.
...
By default integers have a precision of 10 digits. Specify a different integer length in the Basic Settings → Precision.
If you store a number with decimal places as an integer it will be truncated.
Float
Apply a float type float type to non-integer numbers with an undefined level of precision.
Anchor Decimal Decimal
Decimal
Decimal | |
Decimal |
Apply a decimal type decimal type to non-integer numbers with a set level of precision. Decimals have a specific number of:
...
Note |
---|
Ensure your decimal type has the number of decimal places you need for your data. Once the data is loaded into PhixFlow, you will not be able to recover excess decimal placesdata. Once the data is loaded into PhixFlow, you will not be able to recover excess decimal places. |
The PhixFlow administrator can configure the default number of decimal places is set in System Configuration → General Settings → Decimal places.
If the System Configuration or Number Format option to Suppress Trailing Zeroes is set, PhixFlow will display decimals and floating point numbers without trailing zeroes.
Date
Apply a date type to representations of a calendar day. Word formats, such as Tuesday the fourteenth of February are not recognised. However, three letter month abbreviations are recognised, for example: 14 Feb 2019.
...
- y represents year digits
- M represents month digits or MMM represents three letters
- d represents day digits
- separators can be forward slash / hyphen - or a space- or a space.
The default number of date format is set in System Configuration → General Settings → Default Date Format.
Recognised Date Formats
- the international standard format has not separators and is yyyyMMdd, for example 20190214.
- the following variations (examples shown with space separators).
14 02 2019 | 14 Feb 2019 | 02 14 2019 | Feb 14 2019 |
---|---|---|---|
dd/MM/yyyy | dd-MMM-yyyy | MM/dd/yyyy | MMM/dd/yyyy |
dd-MM-yyyy | dd/MMM/yyyy | MM-dd-yyyy | MMM-dd-yyyy |
dd MM yyyy | dd MMM yyyy | MM dd yyyy | MMM dd yyyy |
MM d yyyy | MMM d yyyy | ||
14 02 19 | 14 Feb 19 | 02 14 19 | Feb 14 19 |
dd/MM/yy | dd/MMM/yy | MM/dd/yy | MMM/dd/yy |
dd MM yy | dd-MMM-yy | MM-dd-yy | MMM-dd-yy |
dd-MM-yy | dd MMM yy | MM dd yy | MMM dd yy |
MM d yy | MMM d yy |
Datetime
Apply a datetime type to representations of a day and a time. It cannot be used to represent a time alone.
...
The international datetime uses a full stop/period as a separator between the date and time, yyyyMMdd.HHmmss, for example 20190214.15:35:06.
Note |
---|
PhixFlow recognises date and datetime formats, but does not recognise time-only formats, for example HH:mm:ss. When a database collector loads TIME data, it therefore sets the string data-type. |
Graphic
Is this still available?
TrueFalse
Apply a TrueFalse type to fields that can have the values true
or false
.
The values that are saved as true are:
- any number other than 0
- for a list: all items in the list are true
- the following case-insensitive strings
- true
- t
- yes
- y.
The values that are saved as false are:
...
|
The default number of date format is set in System Configuration → General Settings → Default Date/Time Format.
Graphic
Apply a graphic type to fields that contain image files.
True or False Values
Apply the Basic Settings → Type of TrueFalse to fields that can have the values that represent true
or false
.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
- an empty/null field.