Page tree

 

Support | BlogContact Us | 844.332.2821

Versions Compared

Key

  • 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.
  • If the next value is missing or null, this function generates a missing value.
  • 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
snippetBasic

D code

window value:NEXT(myNumber, 1) order:Date

...

  • Multiple columns and wildcards are not supported.

D s
snippetusage

Required?Data TypeExample Value
YesString (column reference)myColumn

k_integer

Integer representing the number of rows after the current one from which to extract the value.

  • Value must be a positive integer. For negative values, see PREV Function.
  • k=1 represents the immediately following row value.
  • If k is greater than or equal to the number of values in the column, all values in the generated column are missing. If a group parameter is applied, then this parameter should be no more than the maximum number of rows in the groups.
  • If the range provided to the function exceeds the limits of the dataset, then the function generates a null value.
  • If the range of the function is valid but includes missing values, the function generates a missing, non-null value.

D s
snippetusage

 

Required?Data TypeExample Value
YesInteger4

D s
snippetExamples

Example - Examine prior order history

...