Page tree

Trifacta Dataprep


Contents:

On April 28, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.

   

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

This page has no comments.