Skip to main content
The Dynamic Rename tool can be used to dynamically change the name of your columns in three different ways.
The H input anchor in the Dynamic Rename tool is optional. You only need to use this if you want to map column names in the first anchor with new names (D) from the second anchor (H).
The first way is to add a prefix to your column names. The second way to dynamically rename is to fetch a column name from one of your rows in your dataset. The third way to use the Dynamic Rename tool is to dynamically map your column names to another dataset - like a find and replace for column names. If you want to use the Dynamic Rename tool in this way, you need to connect a dataset to the H anchor.
The third option can be very powerful if you work with changing datasets. You can use it to map your columns to a predefined schema and then use a Columns tool to only select the columns that match the schema.

​
Configuration

Select how you want to use the Dynamic Rename tool.
1

Input prefix

Simply input the prefix that you want to add to your column names.
1

Input row with column headers

Simply input the row number that contains your new column names.
To activate this version of the Dynamic Rename tool, connect a dataset to the H anchor. See the exampels below
1

Find columns

Select the column containing the column names from your H anchor dataset to look up in your D anchor.
2

Replace columns

Select the column from your D dataset that should replace the existing column names.

​
Example: Excel File with Column Headers in a Specific Row

I have imported an Excel file with my column header in the the second row. I want to make them my column headers.

​
Example: Map Column Names to Another Dataset

We have a dataset with column names with the following names: text_col, float_col, int_col. We want to change them to Text Column, Decimal Column, Integer Column.