Filter Stage Condition

[kpsita]

Hi,

I have a condition like - Field not in ('1', '2', '3')
Ho do I write this condition in Filter Stage. I tried Field <> ('1', '2', '3'),. but failed.

Also if I am using a transformer constraint, I wanted to know the format I've written is correct. I have a constraint as Field <> '1' or '2' or '3'

Thanks

[kris007]

It should be

Code: Select all

Field <> '1' AND Field <> '2' AND Field <> '3'

Same applies in Transformer stage.

[kpsita]

Thank you Kris.

I have two conditions like count >=2 and Field Not in ('1', '2', '3').

As you said in transformer constraint, I tried
(count>=2) And (Field <>'1' And Field<>'2' And Field<>'3')
But this is giving me wrong output.

Can you please help me if this derivation is correct or not

thanks

[anbu]

You constraints are correct. Trim the field before using it in constraint.

Can you show us your input and output?