Fuzzy Matching Names from 2 Dirty Datasets

[kevin0109]

Dear Alteryx Fam,

I am respectfully seeking assistance with regards to fuzzy matching of two datasets. Specifically, I have encountered challenges in matching names between the two datasets, resulting in an incorrect number of matched records (supposed to have 80 records).

I would greatly appreciate your support in resolving this matter. Attached herewith is my workflow for your reference.

Thank you in advance for your kind attention to this request.

[Zok]

Hello,

You have 144 matches but only 68 are unique

if you know the missing 12, you can work on that to see what the problems are 

[mceleavey]

Hi @kevin0109 ,

I've attached the workflow with a few tweaks:

I've amended the field usage regarding Source and RecordID field. I've also changed the methodology to use the merge method with a source field created on the incoming streams to identify them as different sources.

I have changed the algorithms used in the Fuzzy match to focus on names and slightly tweaked the thresholds:

This allows the non-identical matches to be returned as well, and their corresponding matching scores to records not in their source.

I've attached the workflow for you.

I hope this helps,

M.