Need Help in FUZZY MATCHING - COMPARING two columns and Getting the MATCHING SCORE

Question

Hi,

The file has 4 columns (2020 rest, 2019 rest, 2020 menu, 2019 menu).
I want to compare 2 columns to each other (2020 rest to 2019 rest) (2020 menu to 2019 menu) and then get the % match as well for it.
This is my first time performing fuzzy matching hence I am a little bit confused about how to get it. I have attached the input file as well as the desired output. Any help is appreciated. Thanks.

Desired Output:

Example Fuzzy Match.xlsx

grazitti_sapna · Accepted Answer

Hi @iamviraj13 , try this workflow if it helps.

Thanks.

RobertOdera · Accepted Answer

Hi, @iamviraj13

Please mark as a solution (really just a possible solution) + like, if this helps you out.

Here is how I would approach it.

I had to eat my veggies on this one (it's been a while since I run Fuzzy).

By the way, you can now also leverage the Make Group Tool with Fuzzy Matching (in the interest of time, another day perhaps!).

Keep in mind that your results will vary based on the Style algorithm selection (customization) + your % threshold settings.

What I try to do, typically, is:

1. start with high % threshold + tag matches as match level 1

2. process unmatched from first fuzzy match with a lower (bottom) % threshold + tag those matches as match level 2

3. update null match scores to zero

4. add a sort tool at the end to manipulate slice and dice (sort by match level, and match score variations) and analyze further if necessary

The workflow is attached.

Cheers!