Fuzzy Matching-issue with matching

[Anastasio_Theohari]

Hello guys,

I would like to ask why in these data samples the fuzzy matching does not working?

It is just two simple rows but it take it as not similar?

thank you

[atcodedog05]

Hi @Anastasio_Theohari 

The strings lengths are very short.

Try with longer strings.

[atcodedog05]

Hi @Anastasio_Theohari 

Here is an example where there are matches.

Output:

Hope this helps 🙂

[Anastasio_Theohari]

i cannot catch in somehow short strings lenghts?

for example my production data is neccesary to find matching in these two cases,

BP     -        BP/Amoco

Thank you,

[atcodedog05 · Accepted solution]

Hi @Anastasio_Theohari 

Thats exactly the issue Fuzzy match algorithms dont work on short strings.

But here is an hack.

I am adding a padding text "AA" to all column to increase the length.

Output:

Hope this helps. Please check and let me know🙂

[Anastasio_Theohari]

it works now perfect..thank you very much!!

[atcodedog05]

Happy to help 🙂 @Anastasio_Theohari 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[Anastasio_Theohari]

Hi @atcodedog05 ,

i would like to ask you a last question...

i continue notice a strange beheavour with the fuzzy matching..

Look my example,i set also a new row which is very similar,this is Shell and Texaco/Shell but still does not take it as similar..

Any idea?

I will appreciate any help...

[atcodedog05 · Accepted solution]

Hi @Anastasio_Theohari 

Fixed it😅

Output:

I just changed padding "AA" to "AA " (with a space)

Hope this helps 🙂

[Anastasio_Theohari]

Thanks a lot!