How to combine multiple workbooks with different tabs with different schema

[Niks_diageo]

Hello Friends / Alteryx champs,

I am new to Alteryx world and stuck in a situation where i want to club multiple workbooks with different tabs and also having different schema..how to combine the same and get the output.

i have made some sample data (4 months employee details) and attaching the same. can you please help to get the solution around the same.

thanks in advance.

Regards,

Nikhil

[patel_bm · Accepted solution]

What have you tried so far.. Do share any attempts and issues you may have faced. 

[T_Willins · Accepted solution]

HI @Niks_diageo,

Below is a link to how to solve this issue in the Alteryx Designer Knowledge Base.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Read-in-Multiple-Excel-Files-with-M...

[patel_bm · Accepted solution]

Here's how it will work based on post shared by @T_Willins. 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Read-in-Multiple-Excel-Files-with-M...

I have attached the modified workflow based on the files you shared.

[Niks_diageo]

Thank you for the quick response... really appreciated..