Description
The Flag Holidays activity scans a date column and flags each row as a Holiday, Weekend, or Weekday. It supports both Infoveave’s predefined holiday calendars and custom holiday lists. You can also define which days of the week are considered weekends.
Use Case
Automatically tag dates in a sales or attendance log as working days, weekends, or public holidays. This is useful for time-series analysis, attendance automation, or business day filtering.
| Type | Description |
|---|
| Data | Dataset with at least one date column. |
Output
| Type | Description |
|---|
| Transformed Data | Data with an additional column indicating the day type. |
Configuration Fields
| Field Name | Required | Description |
|---|
| Date column | Yes | The column containing dates to check against holidays/weekends. |
| Weekly off days | No | List of days considered weekends (e.g., Saturday, Sunday). |
| Output column | Yes | Name of the output column for flags (Holiday, Weekend, Weekday). |
| Include original | No | If enabled, retains original input columns in output. |
| Use Infoveave holidays | No | If enabled, uses Infoveave’s predefined holiday list. |
| Custom holidays | No | Allows adding user-defined holidays with name and date. |
| event_date |
|---|
| 2025-01-01 |
| 2025-08-15 |
| 2025-09-21 |
| 2025-09-23 |
| 2025-09-24 |
Sample Configuration
| Field | Value |
|---|
| Date column | event_date |
| Weekly off days | Saturday, Sunday |
| Output column | flag |
| Include original | Enabled |
| Use Infoveave holidays | Enabled |
| Custom holidays | - New Year – 2025-01-01
- Independence Day – 2025-08-15
|
Sample Output
| event_date | flag |
|---|
| 2025-01-01 | Holiday |
| 2025-08-15 | Holiday |
| 2025-09-21 | Weekend |
| 2025-09-23 | Weekday |
| 2025-09-24 | Weekday |
You can use this activity before time-based aggregations or joins to exclude weekends and holidays from calculations.
