Flag Holidays

Description

This activity checks a column containing dates and flags whether each date is a holiday, a weekend, or a weekday.

Data Only

Transformed Data

Date column The column containing the dates to check for holidays.
Weekly off days A list of days considered as weekly off days (e.g., Sunday, Saturday). Options include all days of the week.
Output column The column where the holiday flags will be stored. Flags will be set as
- “Holiday” if the date is a holiday, regardless of whether it’s a weekend.
- “Weekend” if the date falls on a designated weekly off day but is not a holiday.
- “Weekday” if the date is neither a holiday nor a weekend.
Include original When Enabled includes the original data columns in the output . When Disabled includes only the transformed data in output
Use infoveave holidays Whether to use predefined holiday lists from Infoveave.
Custom holidays A set of user-defined holidays, including
- Name of the Holiday
- Date of the Holiday

alt text