transformations:sort
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
transformations:sort [2015/04/10 15:52] – elenap | transformations:sort [2021/03/29 01:19] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Sort ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Basic\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | Since 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: | + | 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: |
* Errors | * Errors | ||
* Empty cells | * Empty cells | ||
Line 10: | Line 14: | ||
* Numbers | * Numbers | ||
- | In descending order, the sorting order is exactly | + | In descending order, the sorting order is the reverse.\\ |
- | EXAMPLE | + | \\ |
+ | =====Use cases===== | ||
+ | *To find the least/ | ||
+ | *To create an alphabetized list. (text) | ||
+ | *To establish a date-time ordered list. (date) | ||
+ | *To discover errors in a column by grouping them at the top/bottom of the column. | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Columns|Select the column to arrange the values of. | | ||
+ | |Sort order|Options: | ||
+ | Additional columns can be added to the sorting criteria by clicking the //Sort by more columns// option.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | **Example 1 (single-column sort): | ||
**Source table:** The longest rivers in the world | **Source table:** The longest rivers in the world | ||
- | ^ River ^ Length (km) ^ Continent | + | ^River |
- | | Nile | 6650 | Africa | + | | Nile | 6650|Africa |
- | | Amazon | + | | Amazon |
- | | Yangtze | + | | Yangtze |
- | | Mississippi | + | | Mississippi |
- | | Yenisei | + | | Yenisei |
- | | Yellow River | 5464 | Asia | | + | | Yellow River | 5464|Asia |
- | | Ob | 5410 | Asia | | + | | Ob | 5410|Asia |
- | | Paraná | + | | Paraná |
+ | **Action parameters: | ||
- | **Objective:** Arrange the rivers in alphabetical | + | > Column: River |
+ | > Sorting | ||
- | **Transformation | + | |
+ | **Output table:** | ||
+ | |||
+ | ^River | ||
+ | | Amazon | ||
+ | | Mississippi | ||
+ | | Nile | 6650|Africa | ||
+ | | Ob | 5410|Asia | ||
+ | | Paraná | ||
+ | | Yangtze | ||
+ | | Yellow River | 5464|Asia | ||
+ | | Yenisei | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | **Example 2 (two-column sort): | ||
+ | |||
+ | **Action | ||
+ | |||
+ | > Column, Sorting order: Continent, ascending | ||
+ | > Column, Sorting order: River, ascending | ||
- | * Column: River | ||
- | * Sorting order: Ascending | ||
| | ||
**Output table:** | **Output table:** | ||
- | ^ River ^ Length (km) ^ Continent | + | ^River |
- | | Amazon | + | | Nile |
- | | Mississippi | + | | Ob |
- | | Nile | + | | Yangtze |
- | | Ob | + | | Yellow River |
- | | Paraná | + | | Yenisei |
- | | Yangtze | + | | Mississippi |
- | | Yellow River | + | | Amazon |
- | | Yenisei | + | | Paraná |
+ | |||
+ | \\ | ||
+ | =====Shortcuts===== | ||
+ | Fast ways to create the action:\\ | ||
+ | |||
+ | *Right-click on the heading of the column to sort and select " | ||
+ | *To sort by multiple columns, select the columns included in the sort. Right-click on one of the selected column headings and select " | ||
+ | |||
transformations/sort.txt · Last modified: 2021/07/18 23:13 by craigt