Connecting to folder with multiple files

Question

Hello Alteryx Fam -

I am trying to connect to a folder with multiple excel files. All with the same columns headers, but different sheet names.

There are 9 files in the folder all with headers of the snippet attached. I would like to bring in this data and append it all in one place

binu_acs · Answer

@rterry  For the next tool you need to know how to create a batch macro. There are so many posts and videos available in this community about the batch macro. if your company blocks the attachments there is no way I can send you one. After going through those posts try to create one, if not let me know I can explain it to you so that you can follow the same

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

OllieClarke · Answer

@rterry if the sheets in the files are all of the same schema, then you can use a dynamic input tool instead of @binu_acs's batch macros.

The first dynamic input reads in the sheets within all excels

We then create a new fullpath by replacing the <List of Sheet Names> with the actual sheet names

And then we can read in all the sheets from all the excels using the second Dynamic Input

This approach works when the schemas of the sheets and the files are all identical, otherwise you'll need @binu_acs batch macro approach.

Hope that helps,

Ollie

dynamicinputs.yxmd

rterry · Answer

Okay - my directory tool is set up accordingly.

I am not familiar with the batch macro. I have never heard of it until you mentioned it