Forum Discussion

cparrot's avatar
cparrot
Helper 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
Super User
4 years ago

Hi,

In each row of the Test string column, can multiple keywords be found or will only one keyword be found in each row?

  • cparrot's avatar
    cparrot
    Helper I
    4 years ago

    Hello, mulitple keywords can be found per row.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      4 years ago

      Hi,

      Please share data in a format that can be pasted in an MS Excel file.

      • cparrot's avatar
        cparrot
        Helper I
        4 years ago

        cat
        horse
        dog
        string
        yarn
        fence
        goat
        baby
        town
        home
        beaver
        cow
        trailer
        wheels
        rims
        stock
        buy
        tune
        song
        yellow
        green
        blue
        red
        black
        brown
        tan
        gray
        orange
        white
        blue
        tulip
        boat
        flower
        rainbow
        car
        ramp
        bridge
        plane
        jet
        hoverboard
        clock
        bear
        beard
        prince
        king
        skunk
        ship
        water
        sea
        sky
        pond
        fish
        lake
        ocean
        continent
        path
        road
        brighter
        taller
        shorter
        similar
        noticibly
        fast
        slow
        stopped
        pants
        shirt
        garage
        pavement
        chowder
        pb&j

         

         

         

         

        test string
        With this utility you generate a 16 character output based on your input of numbers and upper and lower case letters.  Random strings can be unique. Used in computing, a random string generator can also be called a random character string generator. This is an important tool if you want to generate a unique set of strings. The utility generates a sequence that lacks a pattern and is random.
        Based on your input, get a horse random alpha numeric string. The random string generator creates a series of numbers and letters that have no pattern. These can be helpful for creating security codes.
        Possible applications for a random string generator could be for statistical sampling,
         simulations, and cryptography.  For security cat reasons, a random string generator can be useful. 
        The stench from the feedlot permeated the yellow car despite having the air conditioning on recycled air.
        Truth in advertising and dinosaurs with skateboards have much in common.
        The beach was crowded with snow leopards and a car.
        Improve your goldfish's physical fitness by getting him a bicycle or a plane.
        I often see the time 11:11 or 12:34 on clocks.
        They were excited to see their first sloth.
        Thirty years later, she still thought it was okay to put the toilet paper roll under rather than over.
        Check back tomorrow; I will see if the book has arrived.Dog
        They called out her name boat time and again, but were met with nothing but silence.
        Mary realized if her calculator had a history, it would be more embarrassing than her computer browser history.