View Source

Computes the number of elements in the arrays in the specified column, array literal, or function that returns an array.

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.

Array literal reference example:

arraylen([A,B,C,D])

Output: Returns the count of elements in the array, which is 4.

Column reference example:

arraylen([myValues])

Output: Returns the count of elements in the myValues column.

Array function example:

arraylen(concat([colA,colB]))

Output: Returns the count of elements in the array returned from concatenating colA and colB.

arraylen(array_ref)

Argument	Required?	Data Type	Description
array_ref	Y	string	Name of Array column, Array literal, or function returning an Array to apply to the function

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

Required?	Data Type	Example Value
Yes	String (column reference or function) or array literal	`myArray1`