Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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 Alumni (Retired)

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
Top Solution Authors