Dynamic rename

[VJ_88]

1. I have a excel with data where columns names are not consistent and since columns can be added or removed  every week ,
2. we needed a solution wherein columns could be dynamically renamed basis master list
3. On research we found Dynamic Rename could do what we needed
4. But since main data excel and first rows as F1, F2.... and actual headers are in row 2 as in screenshot 1 
5. Dynamic rename with Take input from Right input is not working for me screenshot 2 
6. Kindly help

[binuacs]

@VJ_88 one way of doing this

[VJ_88]

Thanks @binuacs 

• I understand we can use 02 dynamic rename, 1st to take names as first row 2nd to rename from Right input 
• But, problem is Master has 04 fields name whereas excel where fields name are to be altered has 7+columns ,

1. Screenshot 1 has main excel where columns name are in-correct
2. Screenshot 2 has Master excel
3. Screenshot 3 has Dynamic rename 
4. So, column F1 (4th column) and latter should be renamed from master excel but it maps from 1st column 
5. If  a solution is possible kindly share screenshot as we cannot download Alteryx file on office system as external download are disabled and Alteryx is installed on office system
6.  

Screenshot 1 Source file columns name incorrectScreenshot 2 Master name excelScreenshot 3 dynamic rename output

[binuacs]

@VJ_88 are the first three columns consistent across the excel input files? Date , Name and Record Type?

What is the expected output can you screen shot the expected output?

[binuacs · Accepted solution]

@VJ_88