FLATTEN

All functions > ARRAY > FLATTEN

Flattens a nested array structure into a single-level array.

Syntax

Diagram(
  Sequence(
    Terminal("FLATTEN"),
    Terminal("("),
    NonTerminal("array"),
    Terminal(","),
    OneOrMore(NonTerminal("array"), Terminal(",")),
    Terminal(")"),
  )
)

Notes

• Flattens one level of nesting
• Preserves element order
• Generic type: Array(Array(T)) → Array(T)
• Works with any array element type
• Empty nested arrays are removed from result