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

...

To perform a simple extraction of values without conditionals, use the LIST function. See LIST Function.

D s
snippetBasic

LISTIF
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextpivot value:
listif(hotChocolateLiters, 500, temperature < 0) group:date limit:1

listif(hotChocolateLiters, 500, temperature < 0)

Output:

...

 Returns the values from the hotChocolateLiters

...

column when the temperature value is less than 0. Maximum number of values is 500.

...

 

D s
snippetSyntax

pivot value:LISTIF
d-code
-lang-syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextpivot value:listif(col_ref, limit, test_expression) [group:group_col_ref] [limit:limit_count]

listif(col_ref, limit, test_expression) [group:group_col_ref] [limit:limit_count]


ArgumentRequired?Data TypeDescription
col_refYstringReference to the column you wish to evaluate.
limit_intNintegerMaximum number of values to extract into the list array. From 1 to 1000.
test_expressionYstringExpression that is evaluated. Must resolve to true or false

...