VALUEIN
This section contains reference documentation for the VALUEIN function.
Takes at least 2 arguments, where the first argument is a multi-valued column, and the following arguments are constant values. The transform function will filter the value from the multi-valued column with the given constant values. The VALUEIN transform function is especially useful when the same multi-valued column is both filtering column and grouping column.
VALUEIN('colName', value1, value2,...)
These examples are based on the .