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
Solved! Go to Solution.
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 ?
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.
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
Hi @Benji27
Just curious to know didn't my approach work what was the issue faced so that I can learn from it 🙂