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

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.