User Tools

Site Tools



Category: Transform / Basic


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

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.


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


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

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki