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 [2021/03/23 22:57] – craigt | transformations:sort [2021/03/29 01:19] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
{{ transformations: | {{ transformations: | ||
====== SORT ====== | ====== SORT ====== | ||
- | Category: Transform / Basic | + | Category: Transform / Basic\\ |
+ | \\ | ||
=====Description===== | =====Description===== | ||
- | This transformation | + | This action |
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: | 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: | ||
Line 14: | Line 15: | ||
In descending order, the sorting order is the reverse.\\ | In descending order, the sorting order is the reverse.\\ | ||
+ | |||
+ | \\ | ||
+ | =====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. | ||
+ | |||
\\ | \\ | ||
Line 28: | Line 37: | ||
**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á |
- | **Transformation | + | **Action |
> Column: River | > Column: River | ||
Line 46: | Line 55: | ||
**Output table:** | **Output table:** | ||
- | ^ River ^ Length (km) ^ Continent | + | ^River |
- | | Amazon | + | | Amazon |
- | | Mississippi | + | | Mississippi |
- | | Nile | 6650 | Africa | + | | Nile | 6650|Africa |
- | | Ob | 5410 | Asia | | + | | Ob | 5410|Asia |
- | | Paraná | + | | Paraná |
- | | Yangtze | + | | Yangtze |
- | | Yellow River | 5464 | Asia | | + | | Yellow River | 5464|Asia |
- | | Yenisei | + | | Yenisei |
\\ | \\ | ||
Line 60: | Line 69: | ||
**Example 2 (two-column sort): | **Example 2 (two-column sort): | ||
- | **Transformation | + | **Action |
> Column, Sorting order: Continent, ascending | > Column, Sorting order: Continent, ascending | ||
Line 68: | Line 77: | ||
**Output table:** | **Output table:** | ||
- | ^ River ^ Length (km) ^ Continent | + | ^River |
- | | Nile | 6650 | Africa | + | | Nile | 6650|Africa |
- | | Ob | 5410 | Asia | | + | | Ob | 5410|Asia |
- | | Yangtze | + | | Yangtze |
- | | Yellow River | 5464 | Asia | | + | | Yellow River | 5464|Asia |
- | | Yenisei | + | | Yenisei |
- | | Mississippi | + | | Mississippi |
- | | Amazon | + | | Amazon |
- | | Paraná | + | | 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