Page tree

 

Support | BlogContact Us | 844.332.2821

Versions Compared

Key

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

...

For the window transform, this parameter specifies the column on which to sort the dataset before applying the specified function. For combination sort keys, you can add multiple comma-separated columns.

Info

NOTE: The order parameter only applies to transform steps containing a window function or to the sort transform. For steps that contain a transform supporting an order parameter with a non-window function, the order parameter does nothing.

Info

NOTE: If you are applying a window function, it requires a primary key to identify rows in the output. Otherwise, results can be ambiguous. For more information on defining a primary key, see Window Functions.

Info

NOTE: If it is present, the dataset is first grouped by the group value before it is ordered by the values in the order column.

...