transformations:reorder
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
transformations:reorder [2016/06/12 12:57] – created dmitry | transformations:reorder [2021/07/17 16:38] (current) – [See also] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Reorder columns | + | {{ transformations: |
+ | ====== | ||
+ | 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 |
* 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: | ||
+ | |||
+ | You can add more column movements by clicking //Add rule// or by dragging column headers right in the table' | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Example: | ||
+ | |||
+ | **Source table:** The longest rivers in the world | ||
+ | |||
+ | ^ River ^ Length (km) ^Length (miles) | ||
+ | | Nile | 6650| 4132|Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Move column: Continent | ||
+ | > to position: After column River | ||
+ | |||
+ | \\ | ||
+ | **Result table:** | ||
+ | |||
+ | ^River | ||
+ | | Nile |Africa | ||
+ | |Amazon | ||
+ | |Yangtze | ||
+ | |Mississippi | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====Shortcuts===== | ||
+ | Fast ways to create the action:\\ | ||
+ | |||
+ | *Drag and drop a column to a new location. | ||
+ | *To reorder multiple columns at once, select multiple columns and drag and drop them to their new location. | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | |||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ |
transformations/reorder.1465750673.txt.gz · Last modified: 2016/06/12 12:57 by dmitry