Forum Discussion
M Power Query Lookup words from table
Hello,
I try to do the following in Power Query:
I have a dataset which contains a text column and an other table (lookup table) with a list of words (around 200). If the text from my dataset contains one or more words from the lookup table i want to add those words in a new column (comma seperated)
Below an example of how I would like to have it.
I hope someone can help me with this, thanks in advance!!
Regards, Tiemen
Anonymous
Please see attached file as well
3 Replies
Hi Anonymous
See if this helps
First add a custom column
=Text.SplitAny([Text]," ?")
and then
Text.Combine( List.Select([Custom], each List.Contains(Lookup[Words],_,Comparer.OrdinalIgnoreCase)) , ",")
Zubair_Muhammad Thank you very much!! This works perfectly :smileyvery-happy:
Anonymous
Please see attached file as well