Hello,
I have a number of files with various headers that I am using the Dynamic Rename tool to code into standard headers based on a header dictionary we have. However, what we want to do is drop any columns that don't match when running the tool.
To give more information, the Dynamic Rename 'Rename Mode' is 'Take Field Names from Right Input Rows'. Essentially, all of the data in the header dictionary is stored within rows of data rather than having them as field headers themselves, meaning a join doesn't work for this scenario (unless I have missed something!)
Finally, the number of columns that match and don't match will vary each time we run data through the tool, so would like something dynamic as a solution.
Appreciate any advice you may have in resolving!
Thanks
