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 #1

Move the "Location" column after the "River" column.

Before (source table)

River Length (km) Continent
Nile 6650Africa
Amazon 6400South America
Yangtze 6300Asia
Mississippi 6275North America

After (result table)

River Continent Length (km)
Nile Africa 6650
Amazon South America 6400
Yangtze Asia 6300
Mississippi North America 6275

Action parameters:

Move column: Continent
to position: After column River


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: 2025/01/11 17:32 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki