Fuzzy match but only keep 1 source

[MZ900605]

Hi Team am having a bit of trouble using Fuzzy matching, The first table is Master source contain clean data and way more records than i need.

The second table contain the names but some of them are written with mistakes, I need to match them and add the Lcodes to the second table but only the rows that is in user table. I tried ended up filling user table with all Master records. Any help guys?

ID MASTER	Names	L_codes
6y	Sam leo	324532453
7y	Monica freddy	657568342
8y	Jaye kkk	978686757
9y	Luke QQQ	211324345

ID USER	Names	Codes
16	Sam Loe	AUS22
17	Monica fredy	AUH00
18	Lukee QQQ	AOK33

[atcodedog05]

Hi @MZ900605 

Seems like there are duplicate names in both data source. You need to make names unique in atleast one of the data source to prevent many to many joining.

[MZ900605]

@atcodedog05  Most of the group fields are null 

[atcodedog05 · Accepted solution]

Hi @MZ900605 

That explains please add is not null() like below.

Hope this helps : )

[MZ900605]

group fields mostly null @atcodedog05 

[atcodedog05 · Accepted solution]

Hi @MZ900605 

Can you reduce the Fuzzy match accuracy to 80%. The Null are the ones which didnt get matched.

[MZ900605]

@atcodedog05  yeah this works many thanks but am wondering can I have 2 outputs the one that matched Master and the "user" records that did not match?

[atcodedog05 · Accepted solution]

Hi @MZ900605 

You will be able to get that data in L and R anchor.

Workflow:

Hope this helps : )