Generate Sequence
The Generate Sequence transformation component lets you create a new column containing a numerical sequence. You can configure the starting value, increment, and end value of the sequence. You can then combine this column with other data in your pipeline.
Use case
This component can be used to generate a sequence without any existing data or starting point. You can use this sequence of values as unique identifiers or row numbers in an existing dataset.
Properties
Name = string
A human-readable name for the component.
Start Value = integer
The value of the first generated row.
Increment Value = integer
The number to increment the sequence by on each iteration.
End Value = integer
The maximum value of the sequence. This does not need to be part of the sequence.
Output Column = string
The name of the output column that contains the sequence value.