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]"

Last updated