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

13260 Views

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').