Consolidate data from multiple excel sheets (Multiple Tabs, Inconsistent columns)

[Hammad23]

Hello Community,

I am looking for a macro (prepared and shared by someone from Alteryx community), where I can consolidate data from multiple excel sheets(Multiple Tabs, Inconsistent columns). This was available in the gallery few years back but I can't find it now. So, please help me! Any new similar macro you found in the gallery would also work.

Thanks!

Hammad

[Qiu]

@Hammad23 
This is my collection as well.

[mceleavey]

Hi @Hammad23 ,

Obviously if you have inconsistent columns you will need to do a manual mapping exercise, but I've attached the tools I published a while back to the gallery.

I've also attached an example of how they work.

I hope this helps,

M

[atcodedog05]

Hi @Hammad23 

Try this article

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...

Hope this helps : )