Find keyword phrases from another list

Power Query
1

Hi all,

I have a list called Email Subject. I am trying to match this list with another list that has the email subject but with the person’s name in the subject header. Thanks for your help.

Below is the M:

image
image896×52 2.72 KB

Below is the expected output:

image
image1216×89 3.84 KB

TextContainsSearch.pbix (67.5 KB)

2

Hi Yuhanna,

use fuzzy merging:

image
image870×883 32.6 KB

If you take out Ignore case you should get a pretty good matching rate.
Taking out from the Subject column “{{ contact.firstname }}” should improve the matching.
It makes sense to copy the Subject column and do the replacement and the merging on the Copy, so that you preserve the original Subject content and can also expand it.

Regards,
Matthias

1 Like
3

Hello @ysherriff

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

1 Like
4

Thanks Matthias. Never thought of using fuzzy logic.

Best