Is in

Supported in: Batch, Streaming

Returns true if the list contains the value.

Expression categories: Boolean

Declared arguments

Type variable bounds: T accepts ComparableType

Output type: Boolean

Description: Elements can be arrays. Argument values:

one	two	value	Output
[ 1 ]	[ 2 ]	[ 1 ]	true
[ 1, 2 ]	[ 2 ]	[ 1 ]	false

Description: You can check if the list contains the value. Argument values:

value	Output
BRR-123	true
ABC-543	false

Description: Elements can be structs. Argument values:

one	two	value	Output
{ part: AWE-112, }	{ part: BRR-123, }	{ part: AWE-112, }	true
{ part: CSE-122, }	{ part: BRR-123, }	{ part: AWE-112, }	false

Description: You can check for null. Argument values:

one	two	three	value	Output
1	2	3	null	false
null	null	null	1	false
1	2	null	null	true