Forum Discussion
Solved
Check whether a String contains any elements of a column
Hi,
If I've a table Customers and tells the fruits each customer likes, then I've another table contains all local fruits. I would like to find out what local fruits each customer likes. Pls kindly advise how to achieve this in Power Query. Thanks!
Hi,
With
Fruits = #"Local Fruits"[Fruit]
add column
(x) => Text.Combine(List.Select(Fruits, each Text.Contains(x[Likes], _))," ")
Stéphane
1 Reply
Hi,
With
Fruits = #"Local Fruits"[Fruit]
add column
(x) => Text.Combine(List.Select(Fruits, each Text.Contains(x[Likes], _))," ")
Stéphane