Transformations
Sort Rows
Puts rows in order by a column — A to Z, Z to A, smallest to largest or the reverse.
When to use it
Reach for it whenever the order of the rows matters: a report that must read top to bottom, a first/last choice further down, or simply data that arrives out of sequence.
In a pipeline
File InputSort RowsExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Sort by column | select | Yes | Select column… |
| Direction | select | — | asc |
| Empty cells | select | — | first |
| Then by (JSON, optional) | textarea | — | [{"column":"Region","direction":"asc"}] |
Example
Largest orders first
- Sort by column=Amount
- Direction=Descending (Z→A, 9→0)
| Order | Customer | Amount |
|---|---|---|
| A-1042 | Harbour Foods | 860 |
| A-1041 | Northwind Trading | 1240 |
| A-1043 | Cole & Sons | 312.5 |
| Order | Customer | Amount |
|---|---|---|
| A-1041 | Northwind Trading | 1240 |
| A-1042 | Harbour Foods | 860 |
| A-1043 | Cole & Sons | 312.5 |
Worth knowing
- Numbers sort as numbers and dates as dates, so 9 comes before 10 and text such as "Item 2" comes before "Item 10".
- Empty cells are placed first by default, the way SQL Server and MySQL order them; switch Empty cells to Last to push them to the bottom. The direction never moves them.
- Add more keys with Then by, e.g. [{"column":"Region","direction":"asc","nulls":"last"}] — they break ties in the main column, in the order listed.
- Rows that tie on every key keep the order they arrived in, and the columns are unchanged, so nothing downstream has to be re-picked.