Comparing two sets of data

[alkafalhas]

Hello

I'm working on with two sets of data. Example is as below:

Data set 1

#	Name
1	ANG CHEE KIANG
2	ROSMALIZA BINTI MAZALAN
3	ABDUL B SAID
4	AMANDA LOH FOONG KIT (ABC)
5	KUMAR A/L CHADRAN

Data set 2

#	Name_2
2	ROSMALIZA BINTI MAZALAN
4	LOH FOONG KIT
5	KUMAR CHADRAN
1	ANG CHEE KIANG
3	ABDUL BIN SAID (DEF)

I would like to determine if user 1 is the user 2. Kindly refer below for the expected results: I used join tool to solve for the first 2 scenarios. However, I'm trying to use fuzzy match tool for the rest of cases, but it did not capture all 3 users. Appreciate if someone can help me with this. Thank you

#	Name	Name_2	same user?	Solution
1	ANG CHEE KIANG	ANG CHEE KIANG	Yes	Join tool
2	ROSMALIZA BINTI MAZALAN	ROSMALIZA BINTI MAZALAN	Yes	Join tool
3	ABDUL B SAID	ABDUL BIN SAID (DEF)	Yes	?
4	AMANDA LOH FOONG KIT (ABC)	LOH FOONG KIT	Yes	?
5	KUMAR A/L CHADRAN	KUMAR CHADRAN	Yes	?

[echuong1 · Accepted solution]

Try this:

[afv2688]

Hello @alkafalhas ,

How about this?

Regards

[alkafalhas]

let's say in each data set contains 1 different data that couldn't match. Is there a way to see it from fuzzy match tools? or to display the unmatched data?

Example additional data in set 1

6) Muhammad Ali

Example additional data in set 2

7) Lebron James

[echuong1]

Non-matches will come out of the L and R outputs of the join after the fuzzy match.