Trying to fuzzy match below names
KUMAR, MR. JOHN T
Kumar, John
Please help me with Fuzzy Match Tool configuration to match the above names. Attached workflow.
Solved! Go to Solution.
Hey @gnans19! My suggestion would be to use RegEx to get rid of any "Mr." or "Mrs." qualifications in your name field before performing the fuzzy match.
One other thing you could try would be to separate the first name and last name to separate fields and then fuzzy match on them both. Hope this helps!
@Kenda Yes, I have already got rid of Mr. Mrs. Ms.and it worked
I noticed fuzzy match configurations hwich can ignore puntuations and salutations.
I would like to see this working using configurations chages.
@gnans19 If you click on 'Edit' next to you match style, there is an option that you can choose to strip punctuation and salutations. Is this what you're looking for?
Yes.. I tried this configuration change. But it didn't work. I would like to see a workflow with my sample values matched. I am interested in seeing the configurations.
If you use fuzzy matching and test with 1 case, you might be in for some unexpected results later on in the process. I would caution against only matching with the Name field. My preference would be to have an exact match on the ZIP or very tight match on the address components and a looser matching on the name field. If name only matching is required, you can configure for that but do expect to have over-match results. Even an exact match for John Doe can produce bad results when multiple John Doe's exist in the data.
just 2 more cents from the peanut gallery.
Cheers,
Mark
The reason why you are not getting results is that while the Match Threshold is set to 70%, if you look within the EDIT of the Match Style, the "Name" style has a Match Threshold of 85% set. You can edit that to 75% and you'll see results matching (3 matches). You would unique the results to get to your match. I happen to generally use "Best of Jaro and Levenshtein" as my default.
Cheers,
Mark
Thanks @MarqueeCrew
I took this sample from my large dataset. I couldn't make it match even after playing around with Fuzzy tool configuration. Just wondering if someone can match and share the workflow.
I made the edit described above.
Cheers,
Mark
@MarqueeCrew I ran the workflow, but there is no match