Forum Discussion

Moniek's avatar
Moniek
Resolver I
3 years ago
Solved

Search another table

Hi,    I have a table (TableA) with many many rows and many columns, one column is named Despriction. In another table (TableB) are serveral rows with a part of some discriptions. I want to know in...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi Moniek ,

    In the merge step, there is an option "Fuzzy matching options", expand the option, you can set the similarity threshold, which controls how many words the two values are matching, the defalt value is 0.8, you can reset it based on the fact data. Here I reset it to 0.5, then the "gele banana" matchs "banana".

    There still a option "Ignore case", select it to ignore case when match.

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Moniek's avatar
    Moniek
    3 years ago

    Super!!!! Thanks!!!!

lbendlin's avatar
lbendlin
Super User
3 years ago

Needs more details.  You can do this in either Power Query od DAX but the performance considerations will have a big impact on the eventual choice.

 

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

Moniek's avatar
Moniek
Resolver I
3 years ago

Hi Thanks for your time,

Sample Data:

 

Searching on description in TableA / List TableB. Is the desription something contains of the list than Yes (or 1 of someting like that) else No (or 0 something like that) in the result (tableA and additional Column Check). Hopefully it's clear what I want to do.