I have a dynamic input tool which reads in a list of Excel sheet names, I then filter for the sheet I need, and that sheet has duplicate field names which are there by necessity, although I don't care about them, I don't use those fields. But I get an error about the duplicate field, which isn't really a problem, and I'd prefer to have a clean workflow with no errors or warnings. Can this be avoided?
I didn't include a sample as it includes proprietary data which I didn't want to deal with, I suspect this is a simple and generic enough issue that a sample may not be needed.
Thanks!
Solved! Go to Solution.
Instead of dynamic input, why not use a Batch Macro instead? https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309
That way it will call the exact field you want because then your inputs will be a list of sheet names, and it will be ordered accordingly.
Follow @caltang 's sagely advice. Dynamic Input is one step above multi-row binning in the grand continuum of Alteryx tools. The excel multi-sheet thing is a parlor trick which confuses people and creates more work for people on this forum to try to step in and troubleshoot. You should always use a batch macro.
Thank you! Bit of a pain just to get rid of warnings, it seems like they could just have the dynamic input tool append a sequential number to duplicate field names like the select tool does, but that's not the case, so at least I have an option now. Thanks again!