Scalar FunctionsDynamic / JSON Functions

array_concat

Concatenate dynamic arrays into a single dynamic array.

Syntax

array_concat(arg)

Prop

Type

Returns: dynamic

print array_concat(dynamic([1, 2]), dynamic([3, 4, 5]))

print_0 (dynamic)
[1,2,3,4,5]

weekofyear

Extracts the ISO week number (1-53) from a datetime value.

array_iff

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