Alteryx designer Discussions

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

join multiple columns from different files

How can I join columns from different files a and b below to get c

 

a
12
13

 

b
15
18

 

c
12
13
15
18

 

Highlighted
ACE Emeritus
ACE Emeritus

Hi @amirrafique 

 

Try a Union instead of a Join, and use "Autoconfig by position" (or manually config fields) so that "a" and "b" line up.

 

Hope that helps!

John

Labels