transformations:rename
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 |
Action parameters:
Columns to rename: Continent
Rename to: Location
Result 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 |
Community examples
- Split Excel spreadsheets into multiple spreadsheets (Project; Module: Main; Group: Tab 1; Table: Table 1; Action position: 3)
- Update existing data in a database table (Project; Module: Main; Group: Tab 1; Table: Where clause; Action position: 5)
- Aggregation of consecutive date ranges (Project; Module: Main; Group: Tab 1; Table: Easymorph Patient Example Data.xlsx;
Action position: 12) - Product of Rows in a Column (Project; Module: Main; Group: Tab 1; Table: Initial state; Action position: 2)
- How to process parent-child data structures (Project; Module: Module 1; Group: Tab 1; Table: Longest folder path; Action position: 9)
- Iterate same row in table a known number of times (Project; Module: Main; Group: Group 1; Table: Table 1; Action position: 7)
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: 2021/07/19 01:29 by craigt