Skip to main content

EXAMPLE - Comparison Functions1

This simple example demonstrate available comparison functions:

LESSTHAN - See LESSTHAN Function.
LESSTHANEQUAL - See LESSTHANEQUAL Function.
EQUAL - See EQUAL Function.
NOTEQUAL - See NOTEQUAL Function.
GREATERTHAN- See GREATERTHAN Function.
GREATERTHANEQUAL - See GREATERTHANEQUAL Function.

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: