This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.