Search another table

[Moniek]

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 TableA witch rows contains (parts) descriptions of TableB. How can I make this? In Power Query or Dax?

Thankx!

[v-yanjiang-msft · Accepted solution]

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.

[v-yanjiang-msft]

Hi @Moniek ,

According to your description, here's my solution. I create a sample to clarify.

TableA:

TableB:

1. If the values are exactly match, you can use List.Contains function. Create a custom column.

if List.Contains(TableA[Description],[Description]) then true else false

2. If the values are partially match, you can merge queries.

Select the option "Use fuzzy matching to perform the merge".

Then the partially matched values are filtered out. You can do further calculation based on the column.

I attach my sample below for your reference.

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]

Thanks, this is a part of the solution, this solution does not regocnise when the search desciption contains a part of the discripton. In my example, "gele banaan".

And uppercase letters. Is there somthing you can add it in the Custom coloumn? 

[v-yanjiang-msft · Accepted solution]

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 · Accepted solution]

Super!!!! Thanks!!!!

[lbendlin]

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]

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.