User Profile
Olei_pq
Copper Contributor
Joined 2 months ago
User Widgets
Recent Discussions
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 Oliver69Views0likes2Comments
Recent Blog Articles
No content to show