How to input multiple excel files in a same folder?

[goosekong]

I encountered a problem when I input multiple excel files (all these files are in the same format) in a same folder. Below is the problem. Is there anyone could help to solve it?

1. Use Input Data tool, and set up a connection to the specific folder, use "*" to select all the xlsx files.

2. Then it showed error as all the xlsx files except the first one have a different schema than the 1st file in the set and will be skipped.

[davidskaife · Accepted solution]

Hi @goosekong 

Looks like the files are not in the same format...

Have a look at this KB article and follow the steps, You'll need to use the Batch Macro approach - https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

[goosekong]

Hi David,

Thanks for your suggestion. I'm trying the macro batch solution, but the output mode in "Interface Designer" is not available (grey button), do you know how to make it out? Thanks a lot!

[davidskaife]

Hi @goosekong 

Have you inserted the Macro into your original workflow? The Interface Designer will be available from within the Macro itself.

If you're happy to share the workflow we can take a better look if you get stuck