Need Fuzzy match help

[ganesamurthy]

I have 3 columns and respective values like given below:

Author | Title | ISBN
Author1 | Long book name | 123
Author1 | Long | 123

Actually, title for both rows are same. So I am trying to use Fuzzy match to find it as match, but it is not picking this match. I tried with 'Name' option for Title field in match field section. Even I gave 'Exact' match option for ISBN in match field section along with Title field, but didn't pick as match. Kindly help with solution. Thanks in advance!

[CharlieS]

Could you share the data, or a sample of the data? 

[estherb47]

Hi @ganesamurthy 

If your shorter title is contained within the longer title, then perhaps a Fuzzy Match isn't the most efficient approach here. Have you tried putting the values in the same row and using a Contains function within an IF?

eg.

IF Contains([Long title],[Short title]) then 1 else 2 ENDIF

You can then filter on the 1 or 2 on the matches.

Let me know if this helps.

Cheers!

Esther

[benakesh · Accepted solution]

Hi @ganesamurthy ,

You can reduce match threshold  and change match options   to match .

For title  I reduced  match threshold  ( for example  50 %  )  .

For  isbn  I used  'digits only'  for keys .

[ganesamurthy]

Hi Charlie,

Benakesh in the reply above got an attachment with what I am looking for. Thanks for your interest to reply.

[ganesamurthy]

I actually end up with similar logic only but wondering if Fuzzy match be of any help on such instances. Benakesh in the reponse above got an answer for me.

Thanks for your interest to reply.

[ganesamurthy]

Hi Benakesh, You got my answer. Thanks