rename columns based on a reference table

janez_007

Hi all,

is it possible to create a tool that renames columns based on a reference table?

The tool should be able to read the current column names (the nr. of columns would differ with each load) and make a "vlookup" and rename the found fields with the values from the reference table and keep the original name, if the value would not be found in the reference table.

I have attached an excel, which hopefully demonstrates what I am trying to achieve.

Thank you for your help.

column_rename.xlsx

Kenda

Hi @janez_007!

This is actually quite easy in Alteryx. All you need is the Dynamic Rename tool. Feed your regular input data into the L input and then connect your lookup table into the R input. To configure the Dynamic Rename, select 'Take Field Names from Right Input Rows' in the first drop down for Rename Mode. Then, select Value for your Old Field Name and select Ref as your New Field Name. 

Hope this helps!