Table of Contents
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
| 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 #1
Rename the column "Continent" to the new column name "Location".
Before (source table)
| River | Length (km) | Continent |
|---|---|---|
| Nile | 6650 | Africa |
| Amazon | 6400 | South America |
| Yangtze | 6300 | Asia |
| Mississippi | 6275 | North America |
After (result table)
| River | Length (km) | Location |
|---|---|---|
| Nile | 6650 | Africa |
| Amazon | 6400 | South America |
| Yangtze | 6300 | Asia |
| Mississippi | 6275 | North America |
Action parameters:
Columns to rename: Continent
Rename to: Location
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.