- 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
windowtransform function. However, this parameter is not used.
- You can use the
orderparameters to define the groups of records and the order of those records to which this transform is applied.
- This function works only with the
windowtransform, which is used to create computational windows within a dataset. For more information, see Window Transform.with the following transforms:
window value:FILL(myNumber) order:'Date'