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 |
|
Fields |
Select the field or fields on which you want to apply the function. Tip noteIf you want to apply the same function to multiple fields at once, click the
![]() |
Output 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. |
Property | Configuration |
---|---|
Fields |
Select the field or fields by which to partition. Tip noteIf you want to select multiple fields at once, click the
![]() |
Property | Configuration |
---|---|
Sort by |
Select a field from the incoming data to sort by if you are using the Row number or Rank operations. |
Sort order |
|
Property | Configuration |
---|---|
Start |
|
End |
|
Number of rows (optional) |
If you select Preceding or Following, enter a number of rows to set the range of action of the function. |
To rename the processor or edit its description, click the Edit icon next to the processor name in the Properties panel.