Sequence Transform

If you choose the Sequence type in a transform process and specify a field to group on, a new field of data will display in the result. You can sequence the original data by performing the following operations:

Per group

This operation creates a sequence according to the groups, disregarding the records.

The following table shows an example of the input and output (Start: 1, Step: 1):

InputOutput
A1
A1
B2
C3
C3

Per record

This operation creates a sequence according to the records, disregarding the groups.

The following table shows an example of the input and output (Start: 1, Step: 1):

InputOutput
A1
A2
B3
C4
C5

Record per group

This operation creates a sequence according to the records from each group.

The following table shows an example of the input and output (Start: 1, Step: 1):

InputOutput
A1
A2
B1
C1
C2

Round robin

This operation creates a round robin sequence according to the records, disregarding the groups.

The following table shows an example of the input and output (Start: 1, Count: 2):

InputOutput
A1
A2
B1
C2
C1

Top

This operation enables you to specify a limit and creates a Boolean field as the sequence. It returns "true" from the top to the limited row, and returns "false" afterwards.

InputLimitOutput
A3true
B3true
C3true
D3false
E3false