ARRAY_CONCAT_FUNC
All functions > ARRAY > ARRAY_CONCAT_FUNC
Concatenates multiple arrays into a single combined array with optional deduplication.
Syntax
ARRAY_CONCAT_FUNC(arrays: ARRAY<T>...) → ARRAY<T>sql
Type Parameters:
T: Any type
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
arrays | ARRAY<T>... | Yes | Multiple arrays to concatenate |
deduplicated_on | ANY | Yes | Optional fields to deduplicate on |
Returns
ARRAY - Combined array with all elements
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