Considerations for Formula Fields in Data 360

Raw Data Fields

If you want to reference a raw data field in a formula, use the syntax, sourceField[‘Header Label’] where Header Label corresponds to the column name in your raw data. The syntax sourceField[‘Header Label’] is case-sensitive.

• sourceField is the prefix, sourcefield is incorrect..
• The casing of the Header Label corresponds to the raw data. For example, if the file contains ‘address’, the reference must be ‘address’. If the file contains ‘Address’, the reference must be ‘Address’.
• References to the Header Label must be in single quotes. If the file has a column called ‘address’, the syntax must be sourceField[‘address’], not sourceField[‘Address’].

Free Form Text

To reference a string in your formula, you can use single or double quotes. For example, if you want to check if a value within a raw data field is equal to some string, both expressions are valid:

• sourceField[‘Eye Color’] == “blue”
• sourceField[‘Eye Color’] == ‘blue’

For a given term, don’t mix single and double quote references. For example, the following expressions aren’t valid:

• sourceField[‘Eye Color’] == ‘blue”
• sourceField[‘Eye Color’] == “blue’

Delimiters

If you use a delimiter in your formula, and it's a valid regex character, it must be escaped with a '\\'.

REPLACE('dd.mm.yy','\\.','_')
Output
dd_mm_yy

Numeric Data Types

The output of formula fields that use numeric data types varies depending on the input. For example, these two formulas yield different results where the sourceField['ColumnX'] is 1.54.