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:
This operation creates a sequence according to the groups, disregarding the records.
The following table shows an example of the input and output (Start: 0, Step: 1):
| Input | Output |
|---|---|
| A | 0 |
| A | 0 |
| B | 1 |
| C | 2 |
| C | 2 |
This operation creates a sequence according to the records, disregarding the groups.
The following table shows an example of the input and output (Start: 0, Step: 1):
| Input | Output |
|---|---|
| A | 0 |
| A | 1 |
| B | 2 |
| C | 3 |
| C | 4 |
This operation creates a sequence according to the records from each group.
The following table shows an example of the input and output (Start: 0, Step: 1):
| Input | Output |
|---|---|
| A | 0 |
| A | 1 |
| B | 0 |
| C | 0 |
| C | 1 |
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: 0, Count: 2):
| Input | Output |
|---|---|
| A | 0 |
| A | 1 |
| B | 0 |
| C | 1 |
| C | 0 |