March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
Solved! Go to Solution.
@Anonymous
Please see attached file as well
@Anonymous
Please see attached file as well
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)) , ",")
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
89 | |
86 | |
70 | |
51 |
User | Count |
---|---|
206 | |
150 | |
97 | |
78 | |
69 |