User Tools

Site Tools


transformations:rename

RENAME COLUMNS

Category: Transform / Basic


Description

This action changes the name of one or more columns. Duplicating names are not permitted.


Use cases

  • Align column names with another table prior to merging.
  • Apply column names to tables imported without headings.
  • Truncate long column names.


Action settings

SettingDescription
ColumnSelect the existing column name in the left drop-down
ToSpecify the new column name in the right text box.

Additional columns can be renamed by clicking the Rename more columns option.


Examples

Example #1

Rename the column "Continent" to the new column name "Location".

Before (source table)

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

After (result table)

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

Action parameters:

Columns to rename: Continent
Rename to: Location


Community examples


Shortcuts

Fast ways to create the action:

  • Right-click on the column heading and select Rename… from the context menu.
  • Click the drop-down arrow in the column heading and select Rename… from the context menu.


See also

transformations/rename.txt · Last modified: 2025/01/10 16:31 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki