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.


Use cases


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:


See also