Forum Discussion

cparrot's avatar
cparrot
Icon for Helper I rankHelper I
4 years ago

Fuzzy Matching list size limit?

Hello, i am fuzzy matching in pbi, pulling a list of keywords from excel, then comparing that list of keywords to another excel list of long strings of text. it works fine when the li...
Need Help
Show and Tell
Tips and Tricks
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

cparrot's avatar
cparrot
Icon for Helper I rankHelper I
3 years ago

Hello and thank you for your help with fuzzy matching alternative. however, it appears that a couple of false positives were flagged and im wondering how to make it more accurate?

 

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    I do not understand our doubt.  In the screenshot which i shared with you, Cat and tan appear in the strings very clearly.

    • cparrot's avatar
      cparrot
      Icon for Helper I rankHelper I
      3 years ago

      cat is flagged in two strings, but is actually only present in 1 of the strings.

      tan is flagged, but does not appear in the string from which it is flagged.

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        3 years ago

        Cat appears in the word applications.