Filter by date

Searches a date column for the latest or earliest date and transfers these rows to the results table. All other rows are filtered out. The search can be limited to specific dimensions. If one or more dimensions are specified, the operator determines the feed row with the earliest or latest date within the feed rows with identical dimension values and transfers this to the result table. If there are several feed rows with the earliest or latest date, all of them are transferred to the results table.

The following parameters are available.

Parameter

Description

Source column

Name of the source column for which the earliest or latest date values are determined.

Source: Source table

Data type: Date

Specification: Mandatory

Earliest/latest date

Determines the earliest or latest date values in the source column.

Default value: Earliest date

Dimension column

Dimension for which the earliest or latest date values are determined. Acts as a filter to restrict the values determined.

Data type: Text

Specification: Mandatory

Multiple dimension columns can be set.