Compare Values

Contents:

Depending on the data type, you can compare values in separate columns or single columns against fixed values.

Compare Numeric Values

You can use basic comparison operators to perform comparisons on your data. In this example, the compareCol column is generated as the evaluation of 3 < 6, which is true:

 derive type:single value:(3 < 6) as:'compareCol'

You can paste Wrangle steps into the Transformer Page.

Compare Boolean Values

Boolean values can be true or false, so comparisons like the following can be applied to a Boolean set of values:

set col:Attendance value:IF(isSeated == true,true,Attendance)

Compare Date Values

You can use the DATEDIF function to compare two date values, as in the following, which compares the number of days between startCol and endCol values:

derive type:single value:DATEDIF(startCol, endCol, 'day') as:'durationInDays'

Compare String Values

For string values, you can use the string comparison functions to check how strings compare using Latin collation settings.

Available functions:

• STRINGLESSTHAN Function
• STRINGLESSTHANEQUAL Function
• STRINGGREATERTHAN Function
• STRINGGREATERTHANEQUAL Function

For more information on collation, see String Collation Rules.

You can also use the following functions to evaluate sub-strings within a string which can be compared to other values:

• LEFT Function
• RIGHT Function
• SUBSTRING Function