Extract the public holidays for each federal geman state ("Bundesland") - also extract the vacations ("Schulferien") for a given year.

You can adapt this for other countries as well. Let ChatGPT give you a list of holidays and vacations.

You will have a list of the dates and you can then match which day is a holiday or when schools will be closed. You can count how many states are on holiday. If it is 16 it is a national holiday.

You might have to deal with regional special holiday like the 8th of August in Augsburg "Hohes Friedensfest" or carnival ("Rosenmontag").

--------

Also: Calculate the number of working days between any give dates. Excluding Saturdays and Sundays and also a given list of dates

--------

Also: Check how many Bundesländer's schools will be closed on any given day - for ML you could give weights by the population or use this if you have a location based task

--------

Also: Mark gap days (Brückentage) that are between a public holiday and a weekend for example

DB SQL - PostgreSQL - Load Zoned Date Time Variables

External resources

Used extensions & nodes

KNIME Base nodesTrusted extension

KNIME DatabaseTrusted extension

KNIME Data GenerationTrusted extension

KNIME JavasnippetTrusted extension

KNIME Math Expression (JEP)Trusted extension

KNIME Testing Framework UITrusted extension

Legal

KNIME Base nodes

KNIME Database

KNIME Data Generation

KNIME Javasnippet

KNIME Math Expression (JEP)

KNIME Testing Framework UI