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