...
For a version of this function computed over a rolling window of rows, see ROLLINGLIST Function.
d-codelang-syntax |
---|
RawWrangle | true |
---|
Type | ref |
---|
showNote | true |
---|
WrangleText | pivot value: |
---|
| LISTlist(Name, 500) group:Month limit:1 |
|
...
Output: Returns an array of all values (up to a count of 500
) from the Name
column for each Month
value. The limit
parameter defines the maximum number of output columns.
d-code-lang-syntax |
---|
RawWrangle | true |
---|
Type | syntax |
---|
showNote | true |
---|
WrangleText | pivot value: |
---|
| LISTlist(function_col_ref, [limit_int]) [ group:group_col_ref] [limit:limit_count] |
|
list(function_col_ref, [limit_int]) [ group:group_col_ref] [limit:limit_count] |
Argument | Required? | Data Type | Description |
---|
function_col_ref | Y | string | Name of column to which to apply the function |
limit_int | N | integer (positive) | Maximum number of values to extract into the list array. From 1 to 1000 . |
...