Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Multiple join merge result into one result set

187
8 - Asteroid

I have several dataset with same fields. i used multiple join and the result is like below

187_0-1640658884763.png

what is the quickest way to achieve like below?

187_1-1640659016284.png

 

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@187 
I think A union and a unique tool should do it.

Qiu
21 - Polaris
21 - Polaris

@187 
A quick sample

20211228-187.PNG

Labels
Top Solution Authors