Page tree

Versions Compared

Key

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

D toc

Excerpt

Extracts the set of values from a column into an array stored in a new column. This function is typically part of an aggregation. 

Tip

Tip: To generate unique values for the list, apply the ARRAYUNIQUE function in the next step after this one. See ARRAYUNIQUE Function.

...

For a version of this function computed over a rolling window of rows, see ROLLINGLIST Function.

D s-lang-vs-sql

D s
snippetBasic

LIST
d-code-lang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextpivot value:
list(Name, 500) group:Month limit:1

...

list(Name, 500)

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 s
snippetSyntax

LIST
d-code-lang-syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextpivot value:
list(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]


ArgumentRequired?Data TypeDescription
function_col_refYstringName of column to which to apply the function
limit_intNinteger (positive)Maximum number of values to extract into the list array. From 1 to 1000.

...

Info

NOTE: Do not use the limiting argument in a LIST function call on a flat aggregate, in which all values in a column have been inserted into a single cell. In this case, you might be able to use the limit argument if you also specify a group parameter. Misuse of the LIST function can cause the application to crash.

D s
snippetusage
 

Required?Data TypeExample Value
NoInteger50

...

Include Page
EXAMPLE - LIST and UNIQUE Function
EXAMPLE - LIST and UNIQUE Function

D s also
labelaggregate

...