8.1. Description

Icon: image512

  • Number of inputs: 1.

  • Number of outputs: 1.

Definition

The window function lets you perform a calculation on a set of records that is linked to the current record in the input dataset.

Unlike conventional aggregation functions, the window function does not aggregate records into a single output record: the records retain their separate identities.

Configuration

In order to configure a window function two things need to be specified:

  • Frame boundaries (and - optionally - sorting of the rows in the window).

  • Fields to be calculated.