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

...

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

D s
snippetBasic

D code

pivot value:LIST(Name, 500) group:Month limit:1

Output: Generates a two-column table containing the values for Month and an 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

D code

pivot value: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.

...