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.

​
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