transformations:reorder
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:reorder [2021/03/21 12:22] – craigt | transformations:reorder [2021/07/17 16:38] (current) – [See also] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
{{ transformations: | {{ transformations: | ||
====== REORDER COLUMNS ====== | ====== REORDER COLUMNS ====== | ||
- | Category: Transform / Basic | + | Category: Transform / Basic\\ |
+ | \\ | ||
=====Description===== | =====Description===== | ||
Move one or more columns in the table to the leftmost position, to the rightmost position, or after a particular column. | 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: | |to position|Select the position to move the column to. Options: | ||
- | You can add more column movements by clicking //Add rule//. | + | You can add more column movements by clicking //Add rule// |
- | + | ||
- | \\ | + | |
- | =====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 | **Source table:** The longest rivers in the world | ||
- | ^River | + | ^ River ^ Length (km) ^Length (miles) |
- | | Nile | 6650 | 4132 | Africa | + | | Nile | 6650| 4132|Africa |
- | | Amazon | + | | Amazon |
- | | Yangtze | + | | Yangtze |
- | | Mississippi | + | | Mississippi |
- | + | \\ | |
- | + | **Action | |
- | **Transformation | + | |
> Move column: Continent | > Move column: Continent | ||
> to position: After column River | > to position: After column River | ||
+ | \\ | ||
+ | **Result table:** | ||
- | **Output table:** | + | ^River |
+ | | Nile |Africa | ||
+ | |Amazon | ||
+ | |Yangtze | ||
+ | |Mississippi | ||
- | ^River | + | \\ |
- | | Nile | Africa | + | ====Community examples==== |
- | | Amazon | + | |
- | | Yangtze | + | |
- | | Mississippi | + | |
+ | \\ | ||
+ | =====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 | + | =====See |
- | * [[transformations: | + | |
+ | * [[transformations: | ||
+ | * [[transformations: | ||
* [[transformations: | * [[transformations: | ||
transformations/reorder.txt · Last modified: 2021/07/17 16:38 by craigt