Forum Discussion
Filter Text Field with Keywords
Hello,
first of all. Im really new to all this. I found this post which sounds like my problem but didnt really help me: Solved: Filter text field on containing at least one keywo... - Microsoft Power BI Community
I try to create a Topic Model out of some comments (from users).
For each Topic I create a certain keyword list.
Now I want to filter the comments with a topic key word table and get a new List with the comments which include at least one key word. But not a list with dublicates.
example:
for this example, the new coloumn should only show 3 comments - although comment "6" includes 2 KeyWords
so this should be the outcome:
I try to merge them, but I didnt work, because the comments have multiple caracters.
Thoughts?
Anonymous
I attached the file for you to check how it was done.
2 Replies
- FowmySuper User
Anonymous
I attached the file for you to check how it was done.- AnonymousNot applicable
Thank you very much. 🙂
One more question: Is there a way to upgrade your function that it doesnt only get the correct written words? For example If my filterword is "price"...that it also gets "Price" or "prices"?