This is an old revision of the document!

SORT

Category: Transform / Basic

Description

This transformation sorts the table by one or more columns in ascending or descending order. Order of the columns matters.

Since the values of a column can be of mixed types, the sorting order depends on the value type. For ascending sorting, the order is the following:

In descending order, the sorting order is the reverse.

Setting	Description
Columns	Select the column to arrange the values of.
Sort order	Options: Ascending and Descending. This setting determines the order of the sort for the selected column.

Additional columns can be added to the sorting criteria by clicking the Sort by more columns option.

Example 1 (single-column sort): Arrange the rivers in alphabetical order.

Source table: The longest rivers in the world

Transformation parameters:

Column: River
Sorting order: Ascending

Output table:

Example 2 (two-column sort): Arrange values in ascending order by Continent, then River (using the source table above).

Transformation parameters:

Column, Sorting order: Continent, ascending
Column, Sorting order: River, ascending

Output table: