Free Trial

Alteryx Designer Desktop Discussions

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

how to combine two rows with different amount of rows

luo
8 - Asteroid

I tried to use union and join but it will cause chaos. and combine two rows together.

For Example

 

Input 1:

luo_0-1590127768061.png

Input 2:

luo_1-1590127978831.png

Output:

luo_2-1590128153223.png

 

I didn't find a tool that can help me combine two rows correspondingly. Thanks guys. 

 

 

1 REPLY 1
RolandSchubert
16 - Nebula
16 - Nebula

Hi @luo ,

 

if I got you right, you need both Join and Union. First you join the rows of table 1 and table 2 that match, then you union the matched rows with the one that don't match.
I've attached a sample.

 

Let me know if it works for you.

 

Best,

 

Roland 

Labels
Top Solution Authors