Skip to main content
The Rename transformation component lets you change the names of one or more columns in your dataset. You can choose whether to include all input columns in your dataset, or only the columns that you rename. If you choose to include input columns without renaming them, their names stay the same. You can also use the Rename component to create copies of existing columns by adding them to the column mapping property twice and specifying different names for each new column.

Use case

This component can be used to make your data clearer and enforce consistent naming conventions. For example, you can use it to:
  • Rename unclear column names—for example, change alphanumeric product codes to human-friendly product names.
  • Standardize customer data from different sources—for example, rename the cust_id and customerID columns in different datasets to Customer_ID, so you can combine these datasets for further analysis.

Properties

Name
string
required
A human-readable name for the component.
Column Mapping
column editor
required
In each Source column drop-down, select a column in your dataset that you want to rename. Click the + icon to add another row, or before adding any rows, click Add all to add all input columns to the Source column.In the Target column fields, enter the new name for the selected columns. You can add source columns multiple times to create copies of the same column with different names. Each new name in the Target column must be unique.
Include Input Columns
boolean
required
If Yes, uniquely named input columns will be included in the output. Any renames that duplicate an existing input column will take priority. The default setting is No.