Alteryx Designer Desktop Discussions

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

Join/Union for more than 2 tables

EL1988
6 - Meteoroid

Hi there,

 

I am trying to combine data from 3 tables into 1 table using a common identifier (ID). For 2 tables, I was able to do it via a join & union combination, but was wondering what is the most efficient way of doing it if there are more than 2 tables. Doesn't feel very streamlined to have multiple join & union combinations.

 

My data looks like this:

EL1988_0-1635921649319.png

 

Thank you.

 

1 REPLY 1
AlexEntz
8 - Asteroid

Hello,

 

 the "Join Multiple" Tool should be what you are looking for:

AlexEntz_0-1635922154717.png

 

Greetings Alex

Labels