transformations:reorder
This is an old revision of the document!
Table of Contents
REORDER COLUMNS
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.
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.
Use cases
- Group columns
- Ensure a particular order of columns before exporting to a file
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 |
Transformation 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 |
See Also
transformations/reorder.1616343736.txt.gz · Last modified: 2021/03/21 12:22 by craigt