Concat / Array Layer
Concatenate elements from two fixed-length array columns into a single fixed-length array. Similar to numpy.concatenate() or R's c() for fixed arrays. The resulting array length will be the sum of input array lengths.
Example transformation:
| left_array (len=2) | right_array (len=3) | result (len=5) |
|---|---|---|
| [1, 2] | [3, 4, 5] | [1, 2, 3, 4, 5] |
| [a, b] | [c, d, e] | [a, b, c, d, e] |
| [true, false] | [true, true, false] | [true, false, true, true, false] |
| [1, null] | [3, 4, 5] | [1, null, 3, 4, 5] |
Common applications:
- Combining fixed-width data segments
- Merging split arrays
- Joining sequential measurements
- Combining feature arrays
- Creating composite sequences
- Building fixed-length patterns
Note: All left arrays must have the same fixed length, and all right arrays must have the same fixed length (though left and right lengths can differ). The output array length will be the sum of input lengths. Both input arrays must contain the same type. Null values are preserved in the concatenated result.
SelectLeft
columnThe first fixed-length array column (SelectLeft). Examples:
- Numeric arrays: [1, 2]
- String arrays: [a, b]
- Boolean arrays: [true, false] All arrays in this column must have same length. Must match type with right arrays.
SelectRight
columnThe second fixed-length array column (SelectRight). Examples:
- Numeric arrays: [3, 4, 5]
- String arrays: [c, d, e]
- Boolean arrays: [true, true, false] All arrays in this column must have same length. Must match type with left arrays.
AsColumn
nameName for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.