Sequence
Sequence
Numbers the rows in order and writes the result into a column, with an optional prefix and zero padding.
When to use it
Use it to hand out invoice numbers, line numbers or record ids to rows that arrived without one.
In a pipeline
File InputSequenceExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Generate New Column | checkbox | — | false |
| Column Name | text | — | ID |
| Start Value | number | — | 1 |
| Increment | number | — | 1 |
| Prefix | text | — | e.g. INV- |
| Suffix | text | — | e.g. -2026 |
| Zero Padding | number | — | 0 |
Example
Assign invoice numbers
- Column Name=Invoice No
- Start Value=1
- Prefix=INV-
- Zero Padding=4
| Order | Amount |
|---|---|
| A-1 | 120 |
| A-2 | 80 |
| A-3 | 45 |
| Order | Amount | Invoice No |
|---|---|---|
| A-1 | 120 | INV-0001 |
| A-2 | 80 | INV-0002 |
| A-3 | 45 | INV-0003 |
The counter starts at 1, is padded to four digits, and then the prefix is added.
Worth knowing
- Numbering follows the current row order, so sort or filter before this node rather than after.
- With Generate New Column turned off, the sequence overwrites the chosen existing column instead of adding one.
- Padding applies to the number only, so the prefix does not count toward the digit width.
- The output is always text, even with no prefix and no padding.