Differences

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

--- transformations:reorder [2016/06/12 12:57] – created dmitry
+++ transformations:reorder [2021/03/28 16:33] – [Examples] craigt
@@ Line 1: / Line 1: @@
-===== Reorder columns =====
+{{ transformations:ReorderColumnsAction.png}}
+====== REORDER COLUMNS ======
+Category: Transform / Basic\\
-Move one or more columns in the table to the leftmost position, to the rightmost position, or after particular column.
+\\
+=====Description=====
+Move one or more columns in the table to the leftmost position, to the rightmost position, or after a particular column.
+\\
-**Use cases**
+=====Use cases=====
-  * Group columns
+  * Group columns together
   * Ensure a particular order of columns before exporting to a file
+\\
+=====Action settings=====
+^Setting^Description^
+|Move column|Select the column to be moved.|
+|to position|Select the position to move the column to.  Options:  //Leftmost//, //Rightmost//, //After column// (then select the column\\ to move the selected column to the right of).|
+You can add more column movements by clicking //Add rule// or by dragging column headers right in the table's data grid.\\
+\\
+=====Examples=====
+**Example:**  Move the "Location" column after the "River" column.
+**Source table:** The longest rivers in the world
+^  River  ^  Length (km)  ^  Length (miles)  ^  Continent  ^
+| Nile  |  6650  |  4132  |  Africa  |
+| Amazon  |  6400  |  3976  |  South America  |
+| Yangtze  |  6300  |  3917  |  Asia  |
+| Mississippi  |  6275  |  3902  |  North America  |
+**Action parameters:**
+>  Move column: Continent
+>  to position: After column River
+**Output table:**
+^  River  ^  Continent  ^  Length (km)  ^  Length (miles)  ^
+| Nile  |  Africa  |  6650  |  4132  |
+| Amazon  |  South America  |  6400  |  3976  |
+| Yangtze  |  Asia  |  6300  |  3917  |
+| Mississippi  |  North America  |  6275  |  3902  |
+\\
+=====Shortcuts=====
+Fast ways to create the action:\\
+  *Drag and drop a column to a new location.  The //Reorder columns// action is automatically created.
+  *To reorder multiple columns at once, select multiple columns and drag and drop them to their new location.  The //Reorder columns// action is automatically created.  (To select multiple columns at once: use Shift+click to select contiguous columns; use CTL+click to select noncontiguous columns.)
+\\
+=====See also=====
+  * [[transformations:keepremovecolumns|Keep/Remove columns]]
+  * [[transformations:replacecolumn|Modify column(s)]]
+  * [[transformations:rename|Rename columns]]