Hello Community,
Please find my question below. Do you have any solution ?
I have 3 excel workbook with 5 sheets each. I wanted to combine all the excel workbooks using Alteryx macro into one excel workbook.
Can it be done in alteryx ? I f yes how ?
Please find the attached excel workbook below.
Solved! Go to Solution.
Hi @Chhamanshu ,
I'm attaching one example that uses a sheet finder macro to get all sheets from all files and a batch macro to open one by one and concatenate all of them into the same file.
There is also a great macro from @MarqueeCrew that does exactly what you are looking for. It is the 'Wildcard XLSX Input'
http://www.chaosreignswithin.com/p/macros.html
Let me know if that works for you.
Best,
Fernando Vizcaino
Thanks a lot