Chapter 5. Compare, Sequence and Sort Transforms

Table of Contents

Compare Transform
Equal
Less than
Less than or equal
More than
More than or equal
Next equal
Next less than
Next less than or equal
Next more than
Next more than or equal
Next not equal
Not equal
Previous equal
Previous less than
Previous less than or equal
Previous more than
Previous more than or equal
Previous not equal
Sequence Transform
Per group
Per record
Record per group
Round robin
Top
Sort Transform

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.

InputValueOutput
AAtrue
DAfalse

Less than

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

InputValueOutput
ABtrue
DBfalse

Less than or equal

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

InputValueOutput
ADtrue
DDtrue

More than

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

InputValueOutput
ABfalse
DBtrue

More than or equal

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

InputValueOutput
AAtrue
DAtrue

Next equal

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

InputOutput
Afalse
Dtrue
Dfalse

Next less than

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

InputOutput
1false
4false
4true
3true

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.

InputOutput
1false
4true
4true
3true

Next more than

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

InputOutput
1true
4false
4false
3false

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.

InputOutput
1true
4true
4false
3false

Next not equal

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

InputOutput
Atrue
Dfalse
Dtrue

Not equal

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

InputValueOutput
ADtrue
DDfalse

Previous equal

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

InputOutput
Afalse
Dfalse
Dtrue

Previous less than

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

InputOutput
1true
4true
4false
3false

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.

InputOutput
1true
4true
4true
3false

Previous more than

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

InputOutput
1false
4false
4false
3true

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.

InputOutput
1false
4false
4true
3true

Previous not equal

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

InputOutput
Atrue
Dtrue
Dfalse