Page tree


Support | BlogContact Us | 844.332.2821

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


  • The row from which to extract a value is determined by the order in which the rows are organized at the time that the transform is executed. If you are working on a randomly generated sample of your dataset, the values that you see for this function might not correspond to the values that are generated on the full dataset during job execution.
  • The function accepts a second Integer parameter because it is a window transform function. However, this parameter is not used.
  • You can use the group and order parameters to define the groups of records and the order of those records to which this transform is applied.
  • This function works only with the  window transform, which is used to create computational windows within a dataset. For more information, see Window Transform.with the following transforms:

D s

D code

window value:FILL(myNumber) order:'Date'