Page tree



Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

This simple example demonstrate available comparison functions:

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

Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 11 rates

This page has no comments.