| Excerpt |
|---|
Generates a new column containing the row number as sorted by the order parameter and optionally grouped by the group parameter. |
| Tip |
|---|
Tip: To generate row identifiers by the original order in the source data, use the $sourcerownumber reference. See Source Metadata References. |
This function works with the following transforms:
Example:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | window rownumber() order:Date |
|---|
|
rownumber() |
Output: Returns the row number of each row.
Example with grouping:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | window rownumber() order:Date group:QTR |
|---|
|
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.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | window value:rownumber() order: order_col [group: group_col] |
|---|
|
rownumber() order: order_col [group: group_col] |
For more information on the order and group parameters, see Window Transform.
Example - Rolling window functions
| Include Page |
|---|
| EXAMPLE - Rolling Functions |
|---|
| EXAMPLE - Rolling Functions |
|---|
|
