User Tools

Site Tools


transformations:reorder

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.


Use cases

  • Group columns together
  • Ensure a particular order of columns before exporting to a file


Action settings

SettingDescription
Move columnSelect the column to be moved.
to positionSelect 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 4132Africa
Amazon 6400 3976South America
Yangtze 6300 3917Asia
Mississippi 6275 3902North 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


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/reorder.txt · Last modified: 2021/07/17 16:38 by craigt