Importing multiple excel workbooks having multiple sheets

Hi,

I have around 20 excel workbooks with each one having 4 sheets in them. The schema is same for all. I need to load all these excel workbooks at once in Alteryx so that I get all the data in a single excel workbook having only 4 sheets. I tried the wildcard function but it will require me to take 4 input data tool for getting the 4 sheets. So. I am looking for some other way. Is there anyway? It would really help me a lot if anyone can give any info regarding this

Input

Accepted answers

rkapoor

@Govind_Dileep_G I think this macro will help you to read in the data in one go.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-Batch-Macro-AKA-the-Extra-Dynamic-Dynamic-Input/td-p/329286

All comments

apathetichell

put them in a standalone directory on your computer and use a directory tool... Then try this nifty macro that I have - sending the full path in... (fixed to include .yxzp version)

Excel-lent adventure.yxzp

rkapoor

apathetichell

@rkapoorIf you get a chance can you testdrive my batchs? Trying to get feedback if they work as desired and are therefore gallery-worthy. Hypothetically they should take in an .xlsx or .xls file in a directory and union them all with no limitations on schema or multi-sheet files for .xls. Obviously this is easily done with a batch for .xlsx so the value-add is multi-sheet .xls.

It goes the R-route.

rkapoor

@apathetichell yes sure, I will have a play and let you know

Govind_Dileep_G

Thankyou. Helped a lot

Govind_Dileep_G

Thankyou

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703