ARRAY_CONCAT
All functions > ARRAY > ARRAY_CONCAT
Concatenates multiple arrays into a single combined array with optional deduplication.
Syntax
Diagram(
Sequence(
Terminal("ARRAY_CONCAT"),
Terminal("("),
NonTerminal("array"),
Terminal(","),
OneOrMore(NonTerminal("array"), Terminal(",")),
Choice(0, Skip(),
Sequence(
Terminal("DEDUPLICATED ON"),
NonTerminal("field"),
Terminal(","),
OneOrMore(NonTerminal("field"), Terminal(",")),
)
),
Terminal(")"),
)
)| Parameter | Type | Required | Description |
|---|---|---|---|
array | ARRAY<T> | Yes | Array to concatenate |
field | FIELD | No | Optional fields to deduplicate on |
Notes
- Combines multiple arrays into one
- Preserves order of elements
- Optional DEDUPLICATED ON clause removes duplicates based on specified fields
- Empty arrays are handled gracefully