Forum Discussion
KAURM
4 years agoHelper I
Compare one list (column) to another in Power Query Editor to return a true/false if it appears
Morning, I hope you are all well. I'm struggling with two columns in two queries, the first is in the query #"Key phrases from responses": and the second is in #"Categories" query: ...
- Anonymous4 years ago
Hi KAURM
It looks like they are all lower case already, you can go directly to the query #"Key phrases from responses" to add a custom column
Table.AddColumn(yourPreStep, "yourNewColumnName", each List.Contains(Categories[key phrases],[key phrases])) - 4 years ago
Hi Anonymous
Thank you for your help! I did this before and it didn't work.
Just realised that when using Power BI Text Analytics the key phrases/words have spaces in front of them.
Just trimmed the column and now it works 🙂
Thanks for your help!
KAURM
4 years agoHelper I
Hi Anonymous
Thank you for your help! I did this before and it didn't work.
Just realised that when using Power BI Text Analytics the key phrases/words have spaces in front of them.
Just trimmed the column and now it works 🙂
Thanks for your help!