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
Solved! Go to Solution.
@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-Dynami...
@RishiKIf 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.
@apathetichell yes sure, I will have a play and let you know
Thankyou. Helped a lot
Thankyou