KATER__IS_NOT_ONE_OF

Family: Conditions

Syntax

1
KATER__IS_NOT_ONE_OF(field, value [, ...])

Arguments

Returns

TRUE or FALSE. It is NULL where the field is empty, so a filter leaves that row out.

Usage notes

• A row whose field is empty is left out too, since the comparison with an empty value is not true.

Example

This Sandbox query reads the sample shop’s orders. The table shows the rows that Kater gave.

1
SELECT
2
  orders.region AS "Region",
3
  EVAL(orders.count_distinct__order_id) AS "Orders"
4
FROM kater_dataset.orders AS orders
5
WHERE
6
  KATER__IS_NOT_ONE_OF(orders.region, 'AMER', 'APAC')
7
GROUP BY
8
  orders.region
9
ORDER BY
10
  1

Compiles to

The call compiles to the same SQL on DuckDB and on Snowflake.

1
NOT orders.region IN ('AMER', 'APAC')

See also

• Filters and parameters
• Other functions in Conditions: KATER__IS_EQUAL_TO, KATER__IS_NOT_EQUAL_TO, KATER__IS_GREATER_THAN, KATER__IS_AT_LEAST, KATER__IS_LESS_THAN, KATER__IS_AT_MOST, KATER__IS_BETWEEN, KATER__IS_ONE_OF, KATER__TEXT_CONTAINS, KATER__TEXT_DOES_NOT_CONTAIN, KATER__IS_NULL, KATER__IS_NOT_NULL