Filter with multiple values in external file

Input

Accepted answers

Try something like this

Hope this helps : )

Filter_IN_valuefield (1).yxmd

NikyN

Hello @Benji27,

Please find attached -- as already @atcodedog05 mentioned, the original solution works but only i case that Activity have whole word match to Match columns but now you need to compare also Match to Activity.

Let me know if it works for you!

Best Luck!

Niky

All comments

You can use contains in this scenario.

Hope this helps : )

Benji27

Thank you very much : it works fine if it's the exactly word

But it seems don't work for a part

For example,

Activity :

"Make futures indep"

"Test futures"

Match

"Futures"

Is it work on your side ?

Previously activity has a whole word was present in the match now its not. Hence its not working.

Provide more sample data and expected output I can help you.

Benji27

Hi atcodedog05

Ok sure please find V2 example

The expected output are any rows contains the word "Futures"

Filter_IN_valuefield2.yxmd

Try something like this

Hope this helps : )

Filter_IN_valuefield (1).yxmd

NikyN

Hello @Benji27,

Let me know if it works for you!

Best Luck!

Niky