User Tools

Site Tools


transformations:reorder

Differences

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

Link to this comparison view

Next revision
Previous revision
transformations:reorder [2016/06/12 12:57] – created dmitrytransformations:reorder [2021/07/17 16:38] (current) – [See also] 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 particular column.
  
- +\\  
-**Use cases** +=====Use cases===== 
-  * Group columns+  * Group columns together
   * Ensure a particular order of columns before exporting to a file   * 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
 +
 +\\ 
 +**Result 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|
 +
 +\\ 
 +====Community examples====
 +  * [[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//)
 +  * [[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//)
 +  * [[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=====
 +
 +  * [[transformations:keepremovecolumns|Keep/Remove columns]]
 +  * [[transformations:replacecolumns|Modify column(s)]]
 +  * [[transformations:rename|Rename columns]]
 +
transformations/reorder.1465750673.txt.gz · Last modified: 2016/06/12 12:57 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki