Alteryx Designer Desktop Discussions

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

Combining columns without Join/merging/union

Manojkumar
8 - Asteroid

Hi Team, I have two flows which produce a column each as output.

I have to combine them and output as 2 columns. I tried union but it displaces the row of the columns being merged. Kindly help me.

 

I cannot use Record ID or matches, just a straightforward merging of two columns without operations involved. 

 

Thanks in advance.

 

Ex: 

 

output 1                          

 

1
2
3

 

output 2

A
B
C

 

required output

 

1 a
2 b
3 c

 

 

4 REPLIES 4
CarlDi
Alteryx
Alteryx

hi @Manojkumar can you try the "Join by Record Position" option as opposed to "Join by Specific Fields?"

 

 

ScottE
Alteryx
Alteryx

Hi @Manojkumar 

 

You can use the join tool and set it to join by record position...that would work based on your example.

clipboard_image_0.png

 

Manojkumar
8 - Asteroid

Thanks ! simple solution, thanks for your time

Manojkumar
8 - Asteroid

Thanks Carl, i really appreciate you taking your time for helping me with this

Labels