Skip to Content

How to use NOT IN operator in filter expression editor in calculation view projection node?

I need to filter records based on NOT IN list function. For example

Select * from "sample_schema"."sample_table" where where STATUS NOT IN ('AWAITING','HOLD').

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 22, 2017 at 04:26 PM

    You can write your expression like following:

    not(in("STATUS", 'AWAITING', 'HOLD'))
    Add comment
    10|10000 characters needed characters exceeded