Start Free Trial

Alteryx Designer Desktop Discussions

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

Match and combine data from two input files

raymondchh95
5 - Atom

How do I match data from two input files by matching column [GL] and at the same time including data that are not matched between input A and input B?

 

 

raymondchh95_0-1642341919993.png

 

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @raymondchh95 

 

You can do it with help of join and union tool.

 

Workflow:

atcodedog05_0-1642346918714.png

 

Hope this helps : )

 

Qiu
21 - Polaris
21 - Polaris

@raymondchh95 
We can also use this approach.

0117-raymondchh95.PNG

Labels
Top Solution Authors