Add value fields changing sequence
Description
This transform simply adds a sequence value which resets each time a value changes in the list of specified fields.
Options
Here are the options for the transform:
-
transform name : the name of the transform, needs to be unique in a pipeline
-
Result field: the name of the output field, the sequence
-
Start at value: the number to start at each time
-
Increment by: the value to increase at each row in the same group
-
Init sequence if value of following fields change: you can specify a list of fields here. If a value in one or more of these fields changes compared to the previous rows, the sequence will be reset to the start value.