Window processor
Performs calculations on specific data ranges.
The Window processor allows you to aggregate and perform calculations using values from multiple rows grouped in a range, and produce a value for each row separately.
Usage
The Window processor requires one input flow and can generate only one output flow.
Properties
Properties to configure to create windows aggregations.
| Property | Configuration |
|---|---|
| Operation |
Use the drop-down to select the operation to apply during the windowing process:
|
| Fields | Use the check boxes to select the field or fields on which you want to apply the function. |
| New field name | Give a custom name to the output field or edit it. When more than one field was selected, a name is constructed using the field name, the operation and optional range. |
| Partition by fields | Use the check boxes to select the field or fields by which to partition. |
| Start range |
Use the drop-down to select the end range of the partition:
|
| End range |
Use the drop-down to select the end range of the partition:
|
|
Sort by |
Use the search field to find a field to sort by. Sorting is optional for all operations except for Row number and Rank. |
| Sort order | Select the sorting order between Ascending and Descending. |
To rename the processor or edit its description, point your mouse over the name or description to change in the Properties panel and click the 
Edit icon.