Differences

This shows you the differences between two versions of the page.

--- transformations:sort [2015/04/10 15:52] – elenap
+++ transformations:sort [2021/03/23 22:57] – craigt
@@ Line 1: / Line 1: @@
-===== Sort =====
+{{ transformations:SortAction.png}}
+====== 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 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
   * Empty cells
@@ Line 10: / Line 13: @@
   * Numbers
-In descending order, the sorting order is exactly the opposite.
+In descending order, the sorting order is the reverse.\\
-EXAMPLE
+\\
+=====Action settings=====
+^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.\\
+\\
+=====Examples=====
+**Example 1 (single-column sort):**  Arrange the rivers in alphabetical order.
 **Source table:** The longest rivers in the world
@@ Line 25: / Line 37: @@
 | Ob  |  5410  |  Asia  |
 | Paraná  |  4880  |  South America  |
-**Objective:** Arrange the rivers in alphabetical order
 **Transformation parameters:**
-  * Column: River
+>  Column: River
-  * Sorting order: Ascending
+>  Sorting order: Ascending
 **Output table:**
@@ Line 45: / Line 55: @@
 | Yellow River  |  5464  |  Asia  |
 | Yenisei  |  5539  |  Asia  |
+\\
+\\
+**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:**
+^  River  ^  Length (km)  ^  Continent  ^
+| Nile  |  6650  |  Africa  |
+| Ob  |  5410  |  Asia  |
+| Yangtze  |  6300  |  Asia  |
+| Yellow River  |  5464  |  Asia  |
+| Yenisei  |  5539  |  Asia  |
+| Mississippi  |  6275  |  North America  |
+| Amazon  |  6400  |  South America  |
+| Paraná  |  4880  |  South America  |