M: If text contains in look up table that match criteria, then True

[EZiamslow]

Hi,

How do I go about doing this? I'm trying to get Result column by looking at LookUp table.

If text contains in LookUp table that match the Product, then True else False.

Table1:

Product	Comment	Result
ABC	apple banana cherry	True
BCD	apple orange lemon	True
CDE	coconut watermelon mango	False

LookUp:

Product	Comment
ABC	kiwi
ABC	banana
BCD	orange
BCD	mango
CDE	apple
CDE	cherry
CDE	banana

[EZiamslow]

@slorin Awesome, thanks! 

[slorin · Accepted solution]

Hi @EZiamslow 

let
Source = Table.NestedJoin(Table1, {"Product"}, LookUp, {"Product"}, "LookUp", JoinKind.LeftOuter),
Result = Table.AddColumn(Source, "Result", each List.ContainsAny(Text.Split([Comment], " "), [LookUp][Comment]))
in
Result

Stéphane