Forum Discussion

Olei_pq's avatar
Olei_pq
Copper Contributor
Oct 05, 2025

Power Query- filter Table by a keyword list, partial match

Hello,

 

I have been looking for a solution for a while now to filter a table column with text (approx. 2000 rows) using a list (approx. 50) of keywords in Power Query. The list should be editable by the user in Excel and also contains partial words that I want to identify in the table.

Texts in the table column are usually companies with different spellings, e.g.

Amazon Germany, Amzn US, Bosch, Bsh, Glashuette, glashutte,

Search terms: amazon, bsh, bosch, glash

I have already found solutions for exact matches.

Thank you very much for your help and the great work of the community.

 

Best regards Oliver 

BI & Data Analysis
excel

2 Replies

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Oct 06, 2025

    Hi Olei_pq​ 

    With the information you shared difficult to say more than see PQ https://learn.microsoft.com/en-us/powerquery-m/table-fuzzynestedjoin function and play with its parameters

Resources