Need to join 5 different Excels and bring all the columns from it into one single output

[prduddu]

Hi All,

I have 5 excel sheets with the below format and data. I need to join all of them based on the data below. The end goal is to find all the relevant information for the ID/Name in sheet 1.  Sheet 1 and 2 are joined on  (ID= ID or ID= Manager ID) ; Sheet 1 and 3 are joined on (User ID = User ID); Sheet 1 and 5 are joined based on (ID = ID) but the dept information is derived from Sheet 4 and Sheet 4 and 5 are joined based on (Dept ID = Dept ID). 

I need to pull the Manager ID, Detail1, Detail2, Login ID, Dept Name information for ID/Name in Sheet 1.

I' stuck with using join/multiple joins.Can you please help with the workflow?

I have attached a single sheet with all the 5 sheets templates.

Thanks

PD

[StephenR]

Joins seem to be the way to approach this.  Do you have a sample workflow showing where you are having difficulty?  

[prduddu]

Hi Sruhl,

Nope I am trying to get started and I can't figure out where to begin. I am very new to Alteryx.

Thanks

[DanS · Accepted solution]

Hello, 

I've attached a workflow that joins on all your specifics.

It's also using the union tool to bring in the employee with the missing Detail1, Detail2 and Login ID

Let me know if this is what you were looking for! 

Thanks,

Dan

[prduddu]

Thanks, DanS  :)