Scalar FunctionsDynamic / JSON Functions

array_iff

Element-wise select between two values based on a boolean-array condition.

value_if_true and value_if_false may be scalars (broadcast) or dynamic arrays (indexed positionally); output length follows the condition array.

Syntax

array_iff(condition, value_if_true, value_if_false)

Prop

Type

Returns: dynamic

print array_iff(dynamic([true, false, true]), dynamic([1, 2, 3]), dynamic([4, 5, 6]))

print_0 (dynamic)
[1,5,3]

array_concat

Concatenate dynamic arrays into a single dynamic array.

array_index_of

Return the zero-based index of the first occurrence of `lookup` in `array`, optionally starting at `start_index`.