NOT IN operation in Rule Engine

Hello dear Knimers :green_heart:

Can you please suggest how to use not in in Rule Engine?
For example, I have to exclude the following:

not in
(Brand,
‘E20070520410:Cataract Custom Paks.’,
‘E20090320307:Vit Custom Paks.’)

How can I write it using Rule Engine?

Thanks,
Karlygash

@takbb are you sure? I think if you use
Not $colum$ in (“text”, “text2”) it works

Or am I missing something in the question?
grafik
grafik

grafik

9 Likes

Oops!

@AnotherFraudUser you are quite right, I’ve now deleted my post so that it doesn’t mislead anybody. Clearly I need to have a lie down! :wink:

@Karlygash - I wrote a whole post that was totally wrong, so fortunately @AnotherFraudUser 's post gives the correct example about how to do it, which I’d completely overlooked.

7 Likes

Great!
Sorry to ruin your well done answer :see_no_evil:

4 Likes

I’ve not see what you wrote @takbb before it was deleted, but @AnotherFraudUser is absolutely correct (which you figured out). I use this all the time.

And @Karlygash , this does not limit to just “NOT IN”. You can use “NOT” any other supported operations in the Rule Engine, not just with the “IN” operation.

4 Likes

It’s probably better that way… :crazy_face: :man_facepalming:

2 Likes

hello @AnotherFraudUser @takbb @bruno29a
Thank you very much for your answer) :relaxed:
Much tricky one))
Solved my problem))

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.