Alteryx Macro Excel Workbook

[Chhamanshu]

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.

[fmvizcaino · Accepted 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

[Chhamanshu · Accepted solution]

Thanks a lot