IN returns true for all cases of a column that match any of the values of the match list. An
item in the match list can also be another column (Since: CELONIS 4.7).
Returns false otherwise. The reverse is true for
[NOT] IN can be used in the following contexts:
- CASE WHEN (in the
- Pull-Up-Functions (in the filter argument)
- BIND_FILTERS (in the filter argument)
- CALC_REWORK (in the filter argument)
A match value can also be NULL. A NULL value matches with all NULL values in the match list. NULL values originating from columns in the match list are ignored.
Comparison of strings is case-sensitive