transformations:sort
This is an old revision of the document!
Sort
This transformation sorts the table by one or more columns in ascending or descending order. Order of columns matters.
Since values of a column can be of mixed types, therefore sorting order depends on the value type. For ascending sorting, the order is as follows:
- Errors
- Empty cells
- Boolean values
- Text
- Numbers
In descending order, the sorting order is exactly the opposite.
EXAMPLE
Source table: The longest rivers in the world
River | Length (km) | Continent |
---|---|---|
Nile | 6650 | Africa |
Amazon | 6400 | South America |
Yangtze | 6300 | Asia |
Mississippi | 6275 | North America |
Yenisei | 5539 | Asia |
Yellow River | 5464 | Asia |
Ob | 5410 | Asia |
Paraná | 4880 | South America |
Objective: Arrange the rivers in alphabetical order
Transformation parameters:
- Column: River
- Sorting order: Ascending
Output table:
River | Length (km) | Continent |
---|---|---|
Amazon | 6400 | South America |
Mississippi | 6275 | North America |
Nile | 6650 | Africa |
Ob | 5410 | Asia |
Paraná | 4880 | South America |
Yangtze | 6300 | Asia |
Yellow River | 5464 | Asia |
Yenisei | 5539 | Asia |
transformations/sort.1428695437.txt.gz · Last modified: 2015/04/10 15:50 by elenap