Hiya! I'm building a workflow in order to read in multiple iterations of input files and running into a problem as my column headers change from one input to the other. I've tried Dynamic Rename but I'm maybe using it wrong as it's still failing - the workflow runs fine once, but then when I try to re-run it for a different file, Dynamic Rename fails as the header has now changed name. Hard to describe but imagine that my column changes from "Top-10" to "Top-5" to "Overall" etc - there is no clear pattern. Is there a way where I can use [FieldNumber] in Dynamic Rename and tell it to always rename column 2 to a consistent name?
Hope this makes sense...
Any hints greatly appreciated!
Check out this knowledge base article:
Community > Designer > Designer Knowledge > The Ultimate Input Data Flowchart
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...
Oh I think I've solved it! Although it's a workaround...
Configured my Input tool as per below -