Transformations
Rownum
Adds a SQL ROW_NUMBER() counter: every row gets its own number, with no ties, restarting for each partition.
When to use it
Use it to number rows for a report, to pick the newest record per customer, or to give a batch of rows a simple position.
In a pipeline
File InputRownumFilter Rows
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| New Column Name | text | Yes | Row Number |
| Insert After | select | — | End of table |
| Partition By | select | — | Whole table (no partition) |
| Order By | select | — | Order rows arrive in |
| Order Direction | select | — | asc |
| Start From | number | — | 1 |
Example
Newest order first, per customer
- New Column Name=Order No
- Partition By=Customer
- Order By=Order Date
- Order Direction=Descending
| Customer | Order Date | Total |
|---|---|---|
| Acme | 2026-02-01 | 120 |
| Acme | 2026-05-09 | 80 |
| Harbour | 2026-03-14 | 300 |
| Customer | Order Date | Total | Order No |
|---|---|---|---|
| Acme | 2026-02-01 | 120 | 2 |
| Acme | 2026-05-09 | 80 | 1 |
| Harbour | 2026-03-14 | 300 | 1 |
Keep only the newest per customer by following this node with Filter Rows on Order No equals 1.
Worth knowing
- Unlike Rank, equal rows still get different numbers; the order between them stays the same on every run.
- Start From numbers the rows from something other than 1.
- Leave Partition By empty to number the whole table straight through.