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

RegEx remove Collection of Characters from multiple Columns

External resources

Used extensions & nodes

KNIME Base nodesTrusted extension

KNIME Column Expressions (legacy)Trusted extension

KNIME JavasnippetTrusted extension

Legal

KNIME Base nodes

KNIME Column Expressions (legacy)

KNIME Javasnippet