The Dynamic Rename tool can be used to dynamically change the name of your columns in two different ways.
The o 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 from the second anchor.
The first way to dynamically rename is to fetch a column name from one of your rows in your dataset. If you want to use the Dynamic Rename tool in this way, leave the o anchor empty and simply enter the row number that contains your new column headers. The second way to user the Dynamic Rename tool is to dynamically map your column names to another dataset - like a find and replace for column names.

​
Configuration

Select how you want to use the Dynamic Rename tool.
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 o anchor. See Example 2 below for an example.
1

Find columns

Select the column containing the column names from your o anchor dataset that contains the column names that Less should find in your first anchor.
2

Replace columns

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

​
When To Use

Generally, the Dynamic Rename tool is used to prepare your dataset for further analysis.
  • You’ve uploaded an Excel file via a connection that has a complex structure with headers in a specific row - use the Dynamic Rename tool without the o anchor and select the row number with your column headers
  • The Dynamic Rename tool is excellent when you want to build reusable models that can handle datasets with different input datasets. You can map your incoming data set to a mapping table that handles the uniqueness and ensures the columns become standardized before the rest of your model.

​
Examples

I want to replace my column headers with the content of the first row in my dataset
I want to map my column names to another dataset in order to dynamically replace column names