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

Dynamic rename

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

Developer

@VJ_88 one way of doing this

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 ,

Screenshot 1 has main excel where columns name are in-correct
Screenshot 2 has Master excel
Screenshot 3 has Dynamic rename
So, column F1 (4th column) and latter should be renamed from master excel but it maps from 1st column
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

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

@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?