Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to combine multiple workbooks with different tabs with different schema

Niks_diageo
7 - Meteor

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

4 REPLIES 4
patel_bm
8 - Asteroid

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

T_Willins
14 - Magnetar
14 - Magnetar

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
8 - Asteroid

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
7 - Meteor

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

Labels