MULTI_IN
Description
MULTI_IN
returns true for all cases where one or multiple columns match any tuple of the match list. Returns false otherwise. The reverse is true for NOT MULTI_IN
.
Syntax
MULTI_IN ( (table.column, ...), (value1_1, ...), (value2_1, ...), ...)
NOT MULTI_IN ( (table.column, ...), (value1_1, ...), (value2_1, ...), ...)
Supported types
Supported value types for the match list are STRING, INT, FLOAT, DATE.
Usage
MULTI_IN
can be used in the following contexts:
CASE WHEN (in the
WHEN
conditions)Pull-Up-Functions (in the filter argument)
BIND_FILTERS (in the filter argument)
CALC_REWORK (in the filter argument)
Null handling
A match value can also be NULL. A NULL value matches with all cases of a column that are NULL.
Case sensitivity
Comparison of strings is case-sensitive.
Examples
[1] Single column with tuples containing only one element. This is like the | ||||||||||||
| ||||||||||||
|
[2] | ||||||||||||||||
| ||||||||||||||||
|
[3] Column contains only integers and the tuples contain floats and integers. If a float and an integer represent the same value they match. | |||||||||||||||||||
| |||||||||||||||||||
|
[4] | ||||||||||||||||
| ||||||||||||||||
|
[5] NULL values in a column match against NULL values in the tuples. | ||||||||||||||||||||||
| ||||||||||||||||||||||
|
[6] NULL values can also be used in the first tuple. | |||||||||||||||||||
| |||||||||||||||||||
|
[7] Using | |||||||||||||||||
| |||||||||||||||||
|