Skip to main content
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
required
A human-readable name for the component.
Start Value
integer
required
The value of the first generated row.
Increment Value
integer
required
The number to increment the sequence by on each iteration.
End Value
integer
required
The maximum value of the sequence. This does not need to be part of the sequence.
Output Column
string
required
The name of the output column that contains the sequence value.