arrayConcatString
This section contains reference documentation for the arrayConcatString function.
Concatenates two arrays of strings.
arrayConcatString('colName1', 'colName2')
select DivTailNums,
arrayConcatString(DivTailNums, DivTailNums) AS concatIds
from airlineStats
WHERE arraylength(DivTailNums) >= 2
limit 5
DivTailNums | concatIds |
|---|---|
N7713A,N7713A | N7713A,N7713A,N7713A,N7713A |
N344AA,N344AA | N344AA,N344AA,N344AA,N344AA |
N344AA,N344AA | N344AA,N344AA,N344AA,N344AA |
N7713A,N7713A | N7713A,N7713A,N7713A,N7713A |
Last modified 1yr ago