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
Parameter: Formula type Single row formula
Parameter: Formula LESSTHAN(colA, colB)
Parameter: New column name 'lt'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula LESSTHANEQUAL(colA, colB)
Parameter: New column name 'lte'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula EQUAL(colA, colB)
Parameter: New column name 'eq'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula NOTEQUAL(colA, colB)
Parameter: New column name 'neq'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula GREATERTHAN(colA, colB)
Parameter: New column name 'gt'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula GREATERTHANEQUAL(colA, colB)
Parameter: New column name 'gte'

Results:

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

See Also for EXAMPLE - Comparison Functions1:

This page has no comments.