Alteryx Macro Excel Workbook

Question

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.

Book1.xlsx

Book3.xlsx

Book2.xlsx

fmvizcaino · Accepted Answer

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 Answer

Thanks a lot