##### Page tree

Release 9.2

Contents:

This example illustrates the comparison functions in Designer Cloud Powered by Trifacta® Enterprise Edition.

Functions:

ItemDescription
LESSTHAN Function Returns `true` if the first argument is less than but not equal to the second argument. Equivalent to the `<` operator.
LESSTHANEQUAL Function Returns `true` if the first argument is less than or equal to the second argument. Equivalent to the `<=` operator.
EQUAL Function Returns `true` if the first argument is equal to the second argument. Equivalent to the `=` operator.
NOTEQUAL Function Returns `true` if the first argument is not equal to the second argument. Equivalent to the `<>` or `!=` operator.
GREATERTHAN Function Returns `true` if the first argument is greater than but not equal to the second argument. Equivalent to the `>` operator.
GREATERTHANEQUAL Function Returns `true` if the first argument is greater than or equal to the second argument. Equivalent to the `>=` operator.

Source:

colAcolB
111
210
39
48
57
66
75
84
93
102
111

Transformation:

Add the following transforms to your recipe, one for each comparison function:

Transformation Name `New formula` `Single row formula` `LESSTHAN(colA, colB)` `'lt'`

Transformation Name `New formula` `Single row formula` `LESSTHANEQUAL(colA, colB)` `'lte'`

Transformation Name `New formula` `Single row formula` `EQUAL(colA, colB)` `'eq'`

Transformation Name `New formula` `Single row formula` `NOTEQUAL(colA, colB)` `'neq'`

Transformation Name `New formula` `Single row formula` `GREATERTHAN(colA, colB)` `'gt'`

Transformation Name `New formula` `Single row formula` `GREATERTHANEQUAL(colA, colB)` `'gte'`

Results:

colAcolBgtegtneqeqltelt
111falsefalsetruefalsetruetrue
210falsefalsetruefalsetruetrue
39falsefalsetruefalsetruetrue
48falsefalsetruefalsetruetrue
57falsefalsetruefalsetruetrue
66truefalsefalsetruetruefalse
75truetruetruefalsefalsefalse
84truetruetruefalsefalsefalse
93truetruetruefalsefalsefalse
102truetruetruefalsefalsefalse
111truetruetruefalsefalsefalse