View Source

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:

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