Read multiple Excel files with different sheet names

I've read through many discussions, downloaded the Crew Wildcard input macro and still do not know where to begin.

I have a directory of Excel files with the same schema but different sheet names that I want to read in at once rather than updating the workflow with added input file tools each time there are additions.

Please help!

Datasets

Tips and Tricks

Common Use Cases

Batch Macro

Accepted answers

fmvizcaino

Hi @sonseeahray ,

Since all the files have the same schema, I'm attaching a different and much easier solution.

Take a look and let me know if this makes sense to you.

Best,

Fernando Vizcaino

Multiple tabs and same schema.zip

All comments

fmvizcaino

Hi @sonseeahray ,

In this topic, you have a full tutorial with an example explaining how to do it.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Read-in-Multiple-Excel-Files-with-Multiple-Tabs-that-have/ta-p/51145

I'm also sharing an example of mine with the same idea but different solution.

Let me know if that works for you.

Best,

Fernando Vizcaino

Ex4.zip

fmvizcaino

Hi @sonseeahray ,

Since all the files have the same schema, I'm attaching a different and much easier solution.

Take a look and let me know if this makes sense to you.

Best,

Fernando Vizcaino

Multiple tabs and same schema.zip

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703