AnyIf

Selects an arbitrary element from the given column that matches the specified condition.

AnyIf(column, condition) → any_value

Inputs

• column - The column from which to select an arbitrary element.

• condition - The condition that the element must satisfy.

Example

AnyIf(column2, StartsWith(column2, "M")) → "Milk"
AnyIf(column1, column1 == "[1]") → "[1]"