transformations:sort
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
transformations:sort [2014/10/03 21:45] – dmitry | transformations:sort [2015/04/10 15:50] – elenap | ||
---|---|---|---|
Line 1: | Line 1: | ||
===== Sort ===== | ===== Sort ===== | ||
- | Sort table by one or more columns in ascending or descending order. Order of columns matters. | + | 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 | + | Since values of a column can be of mixed types, therefore |
* Errors | * Errors | ||
* Empty cells | * Empty cells | ||
Line 10: | Line 10: | ||
* Numbers | * Numbers | ||
- | In descending order, the sort order is exactly opposite. | + | In descending order, the sorting |
+ | |||
+ | EXAMPLE | ||
+ | |||
+ | **Source table:** The longest rivers in the world | ||
+ | |||
+ | ^ River ^ Length (km) ^ Continent | ||
+ | | Nile | 6650 | Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | | Yenisei | ||
+ | | Yellow River | 5464 | Asia | | ||
+ | | Ob | 5410 | Asia | | ||
+ | | Paraná | ||
+ | |||
+ | |||
+ | **Objective: | ||
+ | |||
+ | **Transformation parameters: | ||
+ | |||
+ | * Column: River | ||
+ | * Sorting order: Ascending | ||
+ | |||
+ | **Output table:** | ||
+ | |||
+ | ^ River ^ Length (km) ^ Continent | ||
+ | | Amazon | ||
+ | | Mississippi | ||
+ | | Nile | 6650 | Africa | ||
+ | | Ob | 5410 | Asia | | ||
+ | | Paraná | ||
+ | | Yangtze | ||
+ | | Yellow River | 5464 | Asia | | ||
+ | | Yenisei | ||
transformations/sort.txt · Last modified: 2021/07/18 23:13 by craigt