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
20 - Arcturus
20 - Arcturus

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

Qiu
20 - Arcturus
20 - Arcturus

@187 
A quick sample

20211228-187.PNG

Labels