Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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