Fuzzy match on company name

[craigja]

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! 

[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

[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 · Accepted solution]

Hi @craigja,

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

[craigja]

Yep - thats working, thanks!