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. |