Get the rows that contain any of the values from a list

[sundayDriver]

Let's say that we have the following example:

Input

I want to eat; I want a big apple;

You are fine; I'm not hungry;

It's a nice day;

I'm so sleepy

and a keywords list (I can convert it to a table if needed)

Keywords

It's a nice day

hungry

In this example I would like to return:

Results

You are fine; I'm not hungry;

It's a nice day;

I am familiar with search but I couldn't have a list as an input.

Thanks!

Lydia

[camargos88 · Accepted solution]

Hi @sundayDriver ,

You can write this m code:

let _item = [Column1] in
if List.Count(List.Select(tb_Keywords[Column1],
each Text.Contains(_item, _))) > 0 then 1 else 0