PIPELINES
- Introducing pipelines
- Pipelines workspace
- Managing pipelines
- Inputs and outputs
- External sharing
- Join and Union
- Dates
- Automap Values
- Validation
- Operations
- Syntax and functions
- Updates and legacy

DATA

ANALYSE

ADMIN

TUTORIALS
- Pipelines
- Analyse

Equation editor

Functions in Analyse

Valid operators in the equation editor:

plus

minus

divide

multiply

exponent

equals

not equals

greater than

less than

greater than or equal to

less than or equal to

Standard syntax must be followed for the equation editor to function. Quantemplate automatically inserts correct syntax where possible.

' '

" "
IF(...)
,

single quotes for fields in your data. These are added automatically added,
and lozenged if validated.
double quotes for categorical values in your data, eg ‘Region’=“America”
Brackets must follow a function
Comma must follow field or value in the function

Functions

Checks whether a condition is met and returns one value if TRUE, and another value if FALSE.

IF(logical_query,value_if_true,value_if_false)

Examples of logical queries:

'Line_of_Business'="Property"
'Region'="Americas"
'Claim'>1000000

Examples

If the Line of Business is Property, then multiply premium by 1.2. If it is not Property do nothing.

IF('Line_of_Business' = "Property", 'Premium' * 1.2, 'Premium')

Using and/or in IF statements

And statement

IF('Column 1' > 'Column 2' and 'Column 3' < 'Column 4',
value_if_true, value_if_false)

Or statement

IF('Column 1' > 'Column 2' or 'Column 3' < 'Column 4',
value_if_true, value_if_false)

Combined statement

IF((('Column 1' > 'Column 2' or 'Column 1' < 'Column 5')
and ('Column 3' < 'Column 4')), value_if_true, value_if_false)

IFERROR

Returns parameter 2 if the calculation of parameter 1 generates an error.

IFERROR(parameter_1,parameter_2)

Example

If the calculation ‘claim_amount / claim_count’ generates an error, return the value 0.

IFERROR('claim_amount/claim_count',0)

Help Centre