EXAMPLE - Comparison Functions1

Contents:

NOTE: Trifacta Wrangler is a free product with limitations on its features. Some features in the documentation do not apply to this product edition. See Product Limitations.

This example illustrates the comparison functions in Trifacta® Wrangler.

Functions:

Item	Description
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:

colA	colB
1	11
2	10
3	9
4	8
5	7
6	6
7	5
8	4
9	3
10	2
11	1

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:

colA	colB	gte	gt	neq	eq	lte	lt
1	11	false	false	true	false	true	true
2	10	false	false	true	false	true	true
3	9	false	false	true	false	true	true
4	8	false	false	true	false	true	true
5	7	false	false	true	false	true	true
6	6	true	false	false	true	true	false
7	5	true	true	true	false	false	false
8	4	true	true	true	false	false	false
9	3	true	true	true	false	false	false
10	2	true	true	true	false	false	false
11	1	true	true	true	false	false	false

See Also for EXAMPLE - Comparison Functions1:

Send Feedback

Page tree

EXAMPLE - Comparison Functions1