Transform

Sort

Reorders the rows of a table by one column, smallest to largest or largest to smallest. Numbers, dates, and text all sort the way you would expect, and every other column stays aligned with its row.

Inputs

InputAcceptsRequired
TableTableYes

Outputs

OutputProduces
ResultTable

Settings

Typed in on the node or set by the assistant, not wired.

SettingDefaultNotes
ColumnChoose a column from the connected table. The column to sort by. Numbers sort numerically, dates chronologically, text alphabetically.
Ascendingtrue (default) sorts smallest to largest; false sorts largest to smallest.

Example

Your Invoices table lists 800 open invoices. Sort by Days_Outstanding with Ascending set to false, and the most overdue invoices move to the top. The sorted table appears as its own tab, so you can work down the list from worst to best.

Related nodes