Filter with multiple values in external file

[Benji27]

Hello everyone!

I'm trying to make a filter by IN operator and with multiple words values from external file

It works with a single word but not multiple word separated by comma

Can you tell me if it's possible ?

Thanks a lot

[atcodedog05]

Hi @Benji27 

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 ?

[atcodedog05]

Hi @Benji27 

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"

[atcodedog05 · Accepted solution]

Hi @Benji27 

Try something like this

Hope this helps : )

[NikyN · Accepted solution]

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

[atcodedog05]

Hi @Benji27 

Just curious to know didn't my approach work what was the issue faced so that I can learn from it 🙂