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:

Transform:

Add the following transforms to your recipe, one for each comparison function:

derive type:single value:LESSTHAN(colA, colB) as:'lt'

derive type:single value:LESSTHANEQUAL(colA, colB) as:'lte'

derive type:single value:EQUAL(colA, colB) as:'eq'

derive type:single value:NOTEQUAL(colA, colB) as:'neq'

derive type:single value:GREATERTHAN(colA, colB) as:'gt'

derive type:single value:GREATERTHANEQUAL(colA, colB) as:'gte'

Results: