Dynamic input tool gives error with duplicate field names

[apozzy]

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!

[caltang · Accepted 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. 

[apathetichell]

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. 

[apozzy]

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!