KATER__IS_ONE_OF

Family: Conditions

Syntax

1
KATER__IS_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 list parameter, such as a filter with many values, gives all of them. Write it alone, in place of the values.

Example

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

1
SELECT
2
  orders.channel AS "Channel",
3
  EVAL(orders.count_distinct__order_id) AS "Orders"
4
FROM kater_dataset.orders AS orders
5
WHERE
6
  KATER__IS_ONE_OF(orders.channel, 'email', 'web')
7
GROUP BY
8
  orders.channel
9
ORDER BY
10
  1

Compiles to

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

1
orders.channel IN ('email', 'web')

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_NOT_ONE_OF, KATER__TEXT_CONTAINS, KATER__TEXT_DOES_NOT_CONTAIN, KATER__IS_NULL, KATER__IS_NOT_NULL