MULTIPLE EXCEL IN ONE EXCEL

[vijaylnyadav]

HI All,

I have atleast more than 15 excel files and I have to merge all the excel files in one excel files with different tabs of name (15 excel files name) and delete all the previous 15 excel files and have only the resultant one excel file.

Please suggest some solution for this.

Thankyou

[mceleavey]

Hi @vijaylnyadav ,

I've written some macros I use all the time for this.

I've attached the workflow example and the macros. 

I hope this helps.

M.

[Assaf_m]

Have you tried the wildcard xlsx input tool in the crew macros?

if not, check the below link 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CReW-Macro-Support/ta-p/465740