RENAME COLUMNS

Category: Transform / Basic

This action changes the name of one or more columns.

Duplicating names are not allowed.

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

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

Source table: The longest rivers in the world

Action parameters:

Columns to rename: Continent
Rename to: Location

Result table:

• 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)

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.

• Keep/Remove columns
• Modify column(s)
• Reorder columns