Fuzzy match on company name

Hi,

Im trying to match 2 fields in a dataset - one comes from our internal system and the other field is sourced from an online database via an API call. I want to compare the 2 names/fields and produce a fuzzy match which I can then use as I want to make sure that the team have not made a type in the code that the API call uses to look up the company name.

I set the match style to Company Name and in the same workflow below both the A and B fields are exactly the same yet I dont get a match!

FuzzyMatch.yxmd

Fuzzy Match

Accepted answers

grazitti_sapna

Hi @craigja,

Please check the following workflow if it is the same as you desire.

FuzzyMatch.yxzp

All comments

JordyMicheal

Hey there Craig!

You're on the right track, but looking at it a little wrong.
I've attached a workflow for you with some different matches. Also, check out the "Open Example" under the Fuzzy Match tool for more info.

TLDR;

Companies in one row.
Match Key is the group it's matching too

Score is the score between them

FuzzyMatch.yxzp

craigja

Hmm... Sorry I'm still a little (a lot!) confused.... Is it possible to do what I want to do, provide a matching score between 2 fields in the same record?

grazitti_sapna

Hi @craigja,

Please check the following workflow if it is the same as you desire.

FuzzyMatch.yxzp

craigja

Yep - thats working, thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703