How to input multiple excel files in a same folder?

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.

Input

Accepted answers

davidskaife

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

All comments

davidskaife

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703