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.