Flag rows/cells on date range¶
This processor flags rows or cells based on the type of date flag applied: a date range, a relative range, or a date part.
This processor should only be used on columns with meaning ‘Date’, ie. parsed dates.
Action¶
You can select the action to perform on matching (in range) rows:
Remove matching rows
Keep matching rows only
Clear the content of the matching cells
Clear the content of the non-matching cells
Flag on Date Range
Flag rows in the dataset if the date values in a column fall within the boundaries specified by a static range; these boundaries are inclusive. If the lower bound (From) is left empty, all dates before the upper bound (To) are flagged, and vice-versa. If the column does not contain a valid date for a given row, that row is considered as being outside the specified range.
The provided timezone will be used to flag dates.
Flag on Relative Range
Flag rows in the dataset if the date values in a column fall within the boundaries specified by a relative range; these boundaries are dynamic and will update relative to the time on the local server. The relative range is defined using different date periods (year, quarter, month, day) and times (for example: this year, last N years, next N years, year to date). Note: each period is a calendar period; the last 1 year will flag data for the last complete calendar year.
The dates in the dataset as interpreted using the UTC timezone when flagging on relative range.
Flag on Date Range
Flag rows in the dataset if the date values in a column have the same date part(s) as the one(s) specified in the processor. Data can be flagged on a variety of date parts like year, month, week, weekday, day, specific date…
The dates in the dataset as interpreted using the UTC timezone when flagging on date part.