transformations:rename
This is an old revision of the document!
Table of Contents
RENAME COLUMNS
Category: Transform / Basic
Description
This action changes the name of one or more columns.
Duplicating names are not allowed.
Action settings
| Setting | Description |
|---|---|
| Column | Select the existing column name in the left drop-down |
| To | Specify the new column name in the right text box. |
Additional columns can be renamed by clicking the Rename more columns option.
Examples
Example: Rename the column "Continent" to the new column name "Location".
Source table: The longest rivers in the world
| River | Length (km) | Length (miles) | Continent |
|---|---|---|---|
| Nile | 6650 | 4132 | Africa |
| Amazon | 6400 | 3976 | South America |
| Yangtze | 6300 | 3917 | Asia |
| Mississippi | 6275 | 3902 | North America |
Transformation parameters:
Columns to rename: Continent
Rename to: Location
Output table:
| River | Length (km) | Length (miles) | Location |
|---|---|---|---|
| Nile | 6650 | 4132 | Africa |
| Amazon | 6400 | 3976 | South America |
| Yangtze | 6300 | 3917 | Asia |
| Mississippi | 6275 | 3902 | North America |
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.1616961531.txt.gz · Last modified: 2021/03/28 15:58 by craigt