Hello Everyone,
Goal:
I want to dynamically map source data to a template file. I have three inputs. First, I have a template file that needs to be uploaded into ADP. Second, I have source data from a manual excel sheet that has headers that do not map to the template file. Third, I have made a mapping file that has the source data header mapped to the template header.
There are two issues I am running into, one is that my template has column headers that are duplicates and Alteryx is adding in 1,2,3 to the duplicate column headers, which will probably cause errors on upload. The second is that I cannot seem to get the to column headers in the correct order with all of the data.
I have attached an example flow with fake data to show what I am doing. I've tried to look through the community posts for something similar to my issue. I see that there is an ensure fields CReW macro, but from some research it hasn't been updated in awhile and there was a mention of not being able to use it on the Alteryx server.
