Differences

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

--- transformations:reorder [2021/03/21 12:22] – craigt
+++ transformations:reorder [2021/07/17 16:37] – [Examples] craigt
@@ Line 1: / Line 1: @@
 {{ transformations:ReorderColumnsAction.png}}
 ====== REORDER COLUMNS ======
-Category: Transform / Basic
+Category: Transform / Basic\\
+\\
 =====Description=====
 Move one or more columns in the table to the leftmost position, to the rightmost position, or after a particular column.
+\\
+=====Use cases=====
+  * Group columns together
+  * Ensure a particular order of columns before exporting to a file
 \\
@@ Line 12: / Line 19: @@
 |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//.
+You can add more column movements by clicking //Add rule// or by dragging column headers right in the table's data grid.\\
-\\
-=====Use cases=====
-  * Group columns
-  * Ensure a particular order of columns before exporting to a file
 \\
@@ Line 27: / Line 28: @@
 **Source table:** The longest rivers in the world
-^River  ^  Length (km)  ^  Length (miles)  ^  Continent  ^
+^ River  ^ Length (km)  ^Length (miles)  ^Continent  ^
-| Nile  |  6650  |  4132  |  Africa  |
+| Nile  |  6650|  4132|Africa  |
-| Amazon  |  6400  |  3976  |  South America  |
+| Amazon  |  6400|  3976|South America  |
-| Yangtze  |  6300  |  3917  |  Asia  |
+| Yangtze  |  6300|  3917|Asia  |
-| Mississippi  |  6275  |  3902  |  North America  |
+| Mississippi  |  6275|  3902|North America  |
+\\
+**Action parameters:**
-**Transformation parameters:**
 >  Move column: Continent
 >  to position: After column River
+\\
+**Result table:**
-**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|
-^River  ^  Continent  ^  Length (km)  ^  Length (miles)  ^
+\\
-| Nile  |  Africa  |  6650  |  4132  |
+====Community examples====
-| Amazon  |  South America  |  6400  |  3976  |
+  * [[https://community.easymorph.com/t//1686/2|Aggregation of consecutive date ranges]] ([[https://community.easymorph.com/uploads/short-url/xyC5nPd52hGrMiRXjp5w1RVUTYL.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Easymorph Patient Example Data.xlsx//;\\ Action position: //13//)
-| Yangtze  |  Asia  |  6300  |  3917  |
+  * [[https://community.easymorph.com/t//1926/3|Sort column in an export alphabetically (tab)]] ([[https://community.easymorph.com/uploads/short-url/b1cFUp2TMl0yEassYLlT4oO3hxp.morph|Project]]; Module: //Main//; Group: //Reorder columns//; Table: //Reorder columns//;\\ Action position: //2//)
-| Mississippi  |  North America  |  6275  |  3902  |
+  * [[https://community.easymorph.com/t//2017/3|Duplicating rows based on a condition]] ([[https://community.easymorph.com/uploads/short-url/blETeOO6qUVzskyO2eYqMiNvjPP.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1 (2)//; Action position: //8//)
+\\
+=====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=====
+=====See also=====
+  * [[transformations:keepremovecolumns|Keep/Remove columns]]
   * [[transformations:replacecolumn|Modify column(s)]]
   * [[transformations:rename|Rename columns]]