Data Integration and Data Segregation in Alteryx

[SH_94]

Hi Community,

I would like to perform data integration and segregation using alteryx as shown as screenshot below. Basically , i have two sets of data : Data A and Data B. However, there are some information which appear in both data or appear in data A but not appear in Data B. Hence , i would like to do the segregation of data as shown in the screenshot below.

However, i find out it is a bit hard to build the workflow in alteryx and would like to ask if anyone can guide me how to build this in the alteryx. 

I also attached the concept on what i am currently doing as shown as below:

[Qiu · Accepted solution]

@SH_94 
A Join tool can do the work for us.

[Qiu]

@SH_94 
There is a perfect Weekly challenge for this query. Hope you will find it informative.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-71-Recreate-SQL-Joins-in-Alteryx/td-p/61...