Page tree

Versions Compared


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



NOTE: When added to a transformation, this function is applied to the current sample. If you change your sample or run the job, the computed values for this function are updated. Transformations that change the number of rows in subsequent recipe steps do not affect the values computed for this step.


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

D s lang vs sql

D s

D lang syntax
WrangleTextpivot value: listif(hotChocolateLiters, 500, temperature < 0) group:date limit:1

listif(hotChocolateLiters, 500, temperature < 0)