Hi @VeronicaElse
That error is pretty common when trying to read in multiple excel files; as your colleague stated every file must be identical; in layout/format/data type and so forth. Essentially what the tool is doing is reading in a file you specify as the template, and assigning that template layout to every other file you have in the directory. As the error says 'different number of fields' if you compare your template file to the one it's referencing there will be a mismatch in the number of fields being brought through - note that this can also include those 'blank' fields that excel sometimes includes, where there is no data but for some reason excel still thinks there is data there.
The hard way to fix it is go into each file and make sure everything is the same, which defeats the purpose of using Alteryx.
The less hard way would be to filter out the file(s) that don't match the template, and re-run through a new dynamic input with a different template that matches, then union the data back together. I've used this as a quick fix in the past.
The easy solution is to use a macro such as the Wildcard XLSX tool found as part of the CReW macros http://www.chaosreignswithin.com/p/macros.html or the multiple schema macro found on the gallery https://community.alteryx.com/t5/Public-Community-Gallery/Import-Multiple-Schema-Excel-Files/ta-p/91...
Both macros will negate the issue with the Dynamic Input tool and schema/fields etc
If you still have issues, or more questions, posting your workflow and sample data (if you're able to) will help massively in the community being able to solve it :)
