Page tree


Support | BlogContact Us | 844.332.2821

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0411


  • This function calculates the number of elements in the outer layer of an array. If your array is nested, the count of inner elements is not factored.
  • If a row contains a missing array, the returned value is 0. If it contains a value that is not recognized as an array, the returned value is blank.

D s

Array literal reference example:

D code

derive value:ARRAYLEN([A,B,C,D])


D code

derive value:ARRAYLEN([myValues]) as:'length_myValues'

Output: Generates the new new length_myValues column column containing the count of elements in the myValues column. 

Array function example:

D code

derive value:ARRAYLEN(concat([colA,colB])) as:'length_myValues'


Name of the array column, array literal, or function returning an array whose elements you want to count.

  • Multiple columns and wildcards are not supported.

D s


Required?Data TypeExample Value
YesString (column reference or function) or array literalmyArray1

D s

Example - Unnest an array