Flag Holidays
Infoveave Data Automation — Date & Time
Every date in your sales log gets tagged as Holiday, Weekend, or Weekday in one step — so your time-series aggregations exclude non-working days automatically without any manual calendar management.
Sales performance, attendance, call volume, production throughput, and any time-series metric are all distorted when holiday and weekend data points are included without being identified. A report comparing daily sales averages across weeks should exclude Sundays and public holidays from the denominator — but doing that requires knowing which specific dates in your dataset are holidays and which are working days. Flag Holidays adds that classification automatically per row, using Infoveave's predefined holiday calendar for supported regions and any custom holiday list you define, so every downstream aggregation, filter, and time-series analysis operates on correctly classified date rows without any manual calendar lookup or encoding.
What Flag Holidays does
Automatically classify date column values as Holiday, Weekend, or Weekday in Infoveave using predefined and custom holiday lists. Enable business day filtering, time-series analysis with holiday exclusions, and attendance tracking pipelines.
When to use Flag Holidays
- You are analyzing time-series data — daily sales, call volume, production throughput, attendance records — and need to classify each date as a working day, weekend, or public holiday before computing averages, comparisons, or trend lines that should account for non-working day patterns
- You are building an attendance or workforce management pipeline where each event record needs to be tagged as occurring on a weekday, weekend, or holiday so attendance metrics can be segmented and compliance rules can be applied correctly
- You want to filter a time-series dataset to working days only before aggregating daily metrics, and need a Holiday-or-Weekend classification column to use as the filter criteria rather than hardcoding specific date exclusions
- You are processing scheduling or operations data and need to flag dates that fall on public holidays so exceptions, overtime rules, or alert escalations can be triggered automatically for those rows
When to avoid it
- You need to calculate the number of working days between two dates — Flag Holidays classifies individual date rows but does not count business days between two date columns; use Calculate Date Difference for elapsed time and combine with a filter on working day rows for a business day count
- You only need to detect weekends with no holiday classification — use Extract Date Component to extract the DayOfWeek value and apply a filter on weekend day values directly
- Your date column contains date ranges rather than specific dates per row — Flag Holidays classifies individual point dates, not intervals
Where it fits in your Infoveave automation
Flag Holidays is one step inside a multi-step Infoveave workflow. Chain it with other activities — no code, no manual hand-offs.
Build this workflow visually in Infoveave Data Automation — drag, connect, and schedule with no infrastructure setup.
How teams use Flag Holidays
Real scenarios where this transformation saves hours of manual work.
Tag Sales Dates for Holiday-Aware Performance Reporting
A retail analytics team processes daily sales transaction data and needs to analyze same-store sales on working days versus holiday periods. Flag Holidays classifies each transaction date as Holiday, Weekend, or Weekday using Infoveave's predefined holiday calendar plus a custom list of store-specific sale events treated as high-traffic days. The team can then filter to weekday-only rows for baseline performance analysis and separately aggregate holiday-period sales for promotional effectiveness reporting.
Exclude Holiday and Weekend Production Logs from OEE Calculation
A manufacturing operations team processes machine production event logs where events on Saturdays, Sundays, and plant holidays should be excluded from OEE calculation denominators. Flag Holidays adds a DayType column to the production log dataset classifying each log date. The team filters the dataset to Weekday rows only before computing OEE, ensuring the operational efficiency metric reflects only planned production days rather than being diluted by zero-production weekend and holiday rows.
Identify Non-Business Day Transactions for Compliance Flagging
A financial compliance team processes transaction records and needs to identify transactions that occurred on weekends or public holidays — which may be subject to additional regulatory review depending on the transaction type and jurisdiction. Flag Holidays tags each transaction date with its day type using regional public holiday calendars. The team applies a filter on Holiday and Weekend rows to produce the compliance review queue for transactions occurring on non-standard business days.
See Flag Holidays in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
event_dateSaturday, SundayflagEnabledEnabledNew Year 2025-01-01, Independence Day 2025-08-15Input Data
| event_date |
|---|
| 2025-01-01 |
| 2025-08-15 |
| 2025-09-21 |
| 2025-09-23 |
| 2025-09-24 |
Output Data
| event_date | flag |
|---|---|
| 2025-01-01 | Holiday |
| 2025-08-15 | Holiday |
| 2025-09-21 | Weekend |
| 2025-09-23 | Weekday |
| 2025-09-24 | Weekday |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Date column
Select the column containing the date values to classify. Each row's date is evaluated against the configured weekly off days and holiday lists to determine its flag value. The column should contain date strings in any recognizable format.
Weekly off days
Specify which days of the week are considered weekends or non-working days. Selecting Saturday and Sunday applies the most common five-day workweek convention. Selecting Friday and Saturday applies a Monday-to-Thursday and Sunday workweek convention for regions where Friday is a non-working day. Rows falling on a configured weekly off day that are not also a public holiday receive the Weekend flag.
Use Infoveave holidays
Enable to apply Infoveave's predefined holiday calendar to the date classification. Dates that match predefined public holidays in the configured region receive the Holiday flag, which takes precedence over the Weekend flag — a date that is both a public holiday and a Saturday is flagged as Holiday rather than Weekend.
Custom holidays
Add your own holiday dates with names for organization-specific, regional, or industry-specific non-working days that are not included in the predefined calendar. Each custom holiday entry specifies a name and a date. Custom holiday dates receive the Holiday flag and take precedence over the Weekend classification for dates that overlap. This allows plant shutdown days, store closure events, or jurisdiction-specific holidays to be incorporated into the classification.
Output column
Name the column that will hold the classification result for each row. The output values are the three text labels Holiday, Weekend, and Weekday. Use the output column downstream as a filter dimension — filtering to Weekday rows only — or as a grouping column for side-by-side comparisons of metrics across the three day type categories.
Frequently asked questions
Everything you need to know about Flag Holidays in Infoveave.
Also in Date & Time — and what runs before & after
Transformations in the same family as Flag Holidays, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Flag Holidays is one of over 80 transformation activities available inside Infoveave workflows. Chain transformations together — no code, no exports, no waiting for IT.
Ready to see Infoveave in action?
