Chapter 5. Compare, Sequence and Sort Transforms

Chapter 5. Compare, Sequence and Sort Transforms
Prev		Next

Compare Transform

If you choose the Compare type in a transform process, it compares the values from a specified field with a specified value, and returns Boolean values ("true" or "false"). You can compare values by performing the following operations:

Equal

This operation returns "true" for values that are equal to the specified value, and returns "false" otherwise.

Input	Value	Output
A	A	true
D	A	false

Less than

This operation returns "true" for values that are less than the specified value, and returns "false" otherwise.

Input	Value	Output
A	B	true
D	B	false

Less than or equal

This operation returns "true" for values that are less than or equal to the specified value, and returns "false" otherwise.

Input	Value	Output
A	D	true
D	D	true

More than

This operation returns "true" for values that are more than the specified value, and returns "false" otherwise.

Input	Value	Output
A	B	false
D	B	true

More than or equal

This operation returns "true" for values that are more than or equal to the specified value, and returns "false" otherwise.

Input	Value	Output
A	A	true
D	A	true

Next equal

This operation returns "true" for values whose next value is equal to them, and returns "false" otherwise.

Input	Output
A	false
D	true
D	false

Next less than

This operation returns "true" for values whose next value is less than them, and returns "false" otherwise.

Input	Output
1	false
4	false
4	true
3	true

Next less than or equal

This operation returns "true" for values whose next value is less than or equal to them, and returns "false" otherwise.

Input	Output
1	false
4	true
4	true
3	true

Next more than

This operation returns "true" for values whose next value is more than them, and returns "false" otherwise.

Input	Output
1	true
4	false
4	false
3	false

Next more than or equal

This operation returns "true" for values whose next value is more than or equal to them, and returns "false" otherwise.

Input	Output
1	true
4	true
4	false
3	false

Next not equal

This operation returns "true" for values whose next value is not equal to them, and returns "false" otherwise.

Input	Output
A	true
D	false
D	true

Not equal

This operation returns "true" for values that are not equal to the specified value, and returns "false" otherwise.

Input	Value	Output
A	D	true
D	D	false

Previous equal

This operation returns "true" for values whose previous value is equal to them, and returns "false" otherwise.

Input	Output
A	false
D	false
D	true

Previous less than

This operation returns "true" for values whose previous value is less than them, and returns "false" otherwise.

Input	Output
1	true
4	true
4	false
3	false

Previous less than or equal

This operation returns "true" for values whose previous value is less than or equal to them, and returns "false" otherwise.

Input	Output
1	true
4	true
4	true
3	false

Previous more than

This operation returns "true" for values whose previous value is more than them, and returns "false" otherwise.

Input	Output
1	false
4	false
4	false
3	true

Previous more than or equal

This operation returns "true" for values whose previous value is more than or equal to them, and returns "false" otherwise.

Input	Output
1	false
4	false
4	true
3	true

Previous not equal

This operation returns "true" for values whose previous value is not equal to them, and returns "false" otherwise.

Input	Output
A	true
D	true
D	false

Prev		Next
Timestamp Transform	Home	Sequence Transform