Dynamic Rename Tool
Use Dynamic Rename to rename columns in upstream data. Use this tool to rename a pattern in the column headers, like removing a prefix or replacing underscores with spaces.
Tip
This tool has a One Tool Example. Visit Access Sample Workflows to learn how to access this and many other examples directly in Designer Cloud.
Configure the Tool
Select a Rename Method:
Add Prefix
Add Suffix
Remove Prefix
Remove Suffix
Use Column Names from Right Input Metadata
Add Prefix/Suffix
Selected columns are renamed to include a prefix or suffix. In Enter Prefix or Enter Suffix, enter a prefix or suffix to each selected column header. The new column name is updated with an example column header with the new prefix or suffix.
Remove Prefix/Suffix
Selected columns are renamed to exclude a prefix or suffix.
In Enter Prefix to Remove or Enter Suffix to Remove, enter the prefix or suffix to remove from each selected column header.
Select the report behavior If Prefixes Are Not Removed:
Warn (Continue Data Processing)
Error (Stop Data Processing)
Ignore (Continue Data Processing)
Use Column Names from Right Input Metadata
All columns are updated so the new column names match the column names from a second input that is connected to the R anchor.
Select the report behavior If Number of Columns Differ:
Warn (Continue Data Processing)
Error (Stop Data Processing)
Ignore (Continue Data Processing)
Check Change Column Data Types to change the new column data types to match the data types from the columns in the second input.