# EXAMPLE - Comparison Functions1

This example illustrates the comparison functions in Designer Cloud.

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 Single row formula LESSTHAN(colA, colB) 'lt'
 Transformation Name New formula Single row formula LESSTHANEQUAL(colA, colB) 'lte'
 Transformation Name New formula Single row formula EQUAL(colA, colB) 'eq'
 Transformation Name New formula Single row formula NOTEQUAL(colA, colB) 'neq'
 Transformation Name New formula Single row formula GREATERTHAN(colA, colB) 'gt'
 Transformation Name New formula Single row formula GREATERTHANEQUAL(colA, colB) '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