Rename
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_idandcustomerIDcolumns in different datasets toCustomer_ID, so you can combine these datasets for further analysis.
Properties
Name = string
A human-readable name for the component.
Column Mapping = column editor
All input fields are available, and can be added multiple times to create copies of a field. Use the output field to rename the column.
Click the Add all button to automatically populate the Source Column and Target Column with all the column names from the input source. You can then selectively edit the list if required, but if you click Add all again it will return the list to the default fully populated state, removing any changes you have made.
Include Input Columns = boolean
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.