Skip to main content

EXAMPLE - Comparison Functions1

This example illustrates the comparison functions in Dataprep by Trifacta.

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

In this section: