Generates a new column containing the row number as sorted by the
Tip: To generate row identifiers by the original order in the source data, use the
This function works with the following transforms:
Output: Returns the row number of each row.
Example with grouping:
rownumber() order:Date group:QTR
Output: Returns the row number of each row as ordered by the values in the
Date column grouped by the
QTR values. For each quarter value, the row number counter resets.
rownumber() order: order_col [group: group_col]
For more information on the
group parameters, see Window Transform.