Add value fields changing sequence
Description
Add Value Fields Changing Sequence generates a numeric sequence that automatically resets whenever the value of a specified field changes in the data stream. Use this step when you need row numbering within groups — for example, assigning line numbers per customer, numbering items within each order, or creating sub-sequences for grouped data. The input data should be sorted or grouped on the monitored fields so that identical values appear together in the stream.
Configurations
| Field Name | Description |
|---|---|
| Step name | Specify the name of the step, needs to be unique in a workflow |
| Result field | Specify the name of the output field, the sequence |
| Start at value | Specify the number to start at each time |
| Increment by | Specify the value to increase at each row in the same group |
| Init sequence if value of following fields change | Specify a list of fields here. If a value in one or more of these field’s changes compared to the previous rows, the sequence will be reset to the start value. |