...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
This setting is not available from the repository browser. It opens from:
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
- When 1 or more output pipes from the stream uses the field to 'Filter' the stream.
- When 1 or more output pipes from the stream uses the field in a 'Sort/Group' by action.
...
...
...
...
...
...
...
Access Permissions
...
If you load data without specifying a type what happens?
Does PhixFlow make a best guess at what the type is and if it's not sure, assumes string??
What if you want to change a format - e.g set a decimal or date format?
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?
...
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 PhixFlow instances that use an Oracle database, bigstrings cannot be sorted or aggregated. On Oracle bigstrings may only be filtered with the conditions:
(not) containsis (not) null(not) starts with(not) ends with.
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?
Float
Apply a float type to non-integer numbers with an undefined level of precision. Float numbers have:
- significant figures: the total number of digits stored,
- decimal places: the number of digits after the decimal place.
...
Apply a decimal type to non-integer numbers with a set level of precision. Decimals have a specific number of:
- significant figures: the total number of digits stored,
- decimal places: the number of digits after the decimal place.
The maximum number of integer digits is therefore the significant figure minus the decimal places. By default, decimals have 10 significant figures and 2 decimal places, and therefore 8 integer digits.
If the number of integer digits present in a decimal field exceeds the specified format, running analysis will fail and PhixFlow will report an error.
If the number of decimal digits present in a decimal field exceeds the specified format, PhixFlow will discard the excess decimal places. For example, if a data record includes the number 12.3456, but the decimal type can have 4 significant figures and 2 decimal places, PhixFlow records 12.34.
| Note |
|---|
Ensure your decimal type has the number of decimal places you need for yout data. Once the data is loaded into PhixFlow, you will not be able to recover excess decimal places. |
Date
Apply a date type to representations of a calendar day.
Are there any specific formats to say are recognised/not recognised?
What about word formats e.g. Tuesday the fourteenth of February?
Datetime
Apply a datetime type to representations of a time, or day and time.
Are there any specific formats to say are recognised/not recognised?
Graphic
Is this still available?
TrueFalse
Apply a TrueFalse type to fields that can have the values true or false.
...