| Excerpt |
|---|
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:
| D code |
|---|
derive type:single value:ARRAYLEN([A,B,C,D]) |
Output: Generates the count of elements in the array, which is 4 .
Column reference example:
| D code |
|---|
derive type:single value:ARRAYLEN([myValues]) as:'length_myValues' |
Output: Generates the new length_myValues column containing the count of elements in the myValues column.
Array function example:
| D code |
|---|
derive type:single value:ARRAYLEN(concat([colA,colB])) as:'length_myValues' |
Output: Generates the new length_myValues column containing the count of elements in the array returned from concatenating colA and colB .
| D code |
|---|
derive type:single value: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 |
array_ref
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.
| Required? | Data Type | Example Value |
|---|
| Yes | String (column reference or function) or array literal | myArray1 |
Example - Unnest an array
| Include Page |
|---|
| EXAMPLE - Flatten and Unnest Transforms |
|---|
| EXAMPLE - Flatten and Unnest Transforms |
|---|
|
