Finding Unique Values from 2 datasets

[kyiu]

Hi,

I need to find the 5 unique records highlighted in red below, based on the 2 data sets (left and right).

I've tried to use the unique tool, but that only compares each dataset separately. How can i crosscheck both data sets and split the output into 10 duplicate records, and 5 unique records. 

This dataset is simplified from a larger dataset.

ID	Name	Birthday	Total		ID	Name	Birthday	Total
19850	John Smith	1/1/2020	10		19850	John Smith	1/1/2020	10
19851	James Green	1/2/2020	20		19851	James Green	1/2/2020	20
19852	Mary Doe	1/3/2020	30		19852	Mary Doe	1/3/2020	30
19853	Joseph White	1/4/2020	40		19853	Joseph White	1/4/2020	40
19854	Alex Brown	1/5/2020	50		19854	Alex Brown	1/5/2020	50
19855	Amanda Williams	1/6/2020	60		19855	Amanda Williams	1/6/2020	60
19856	Megan Jones	1/7/2020	70		19856	Megan Jones	1/7/2020	70
19857	Crystal Blue	1/8/2020	80		19857	Crystal Blue	1/8/2020	80
19858	Katie Gray	1/9/2020	90		19858	Katie Gray	1/9/2020	90
19859	Nick Robert	1/10/2020	100		19859	Nick Robert	1/10/2020	100
19860	Jason Adams	1/11/2020	110
19861	Kevin Wright	1/12/2020	120
19862	Vanessa Leonard	1/13/2020	130
19863	Lisa Roosevelt	1/14/2020	140
19864	Paul Washington	1/15/2020	150

[MichaelLaRose · Accepted solution]

Hi @kyiu 

You actually can use a join tool to identify non matching records.

See Attached.

Best,

Michael

[kyiu]

@MichaelLaRose 

Thanks, totally forgot about the join tool. 

[MichaelLaRose]

Hi @kyiu,

Would you mind accepting the answer if you are all set?

It will help others know there is a solution.

Best,

Michael