Icon

Calculate workdays per country

There has been no title set for this workflow's metadata.

There has been no description set for this workflow's metadata.

Holidays in each conutryExclude SaturdayExclude Sundayapply the parameterized start and end date in the config of this node,create a table with a row for each dayadd the weekdayadd a column if it's weekeday or weekendcount the workdays and weekend daysdo all of this for each of the individual rows/casesparameterize start and end dateadd a column with the caseexclude the weekend daysadd the columns start date and end date take sequenquially one row after anotherdata cleaning,rename the columnStart and End date in countriesconvert data type to date and not stringadd the columns that say if it's a holidaydepending on date and countryconvert data type to date and not stringexclude the rows/days that are a holidayadd a column with the countryExcel Reader Row Filter Row Filter Create Date&TimeRange Date&Time to String Rule Engine GroupBy Loop End Table Rowto Variable ConstantValue Column Row Filter Joiner Chunk Loop Start Column Rename CSV Reader String to Date&Time Joiner String to Date&Time Row Filter ConstantValue Column Holidays in each conutryExclude SaturdayExclude Sundayapply the parameterized start and end date in the config of this node,create a table with a row for each dayadd the weekdayadd a column if it's weekeday or weekendcount the workdays and weekend daysdo all of this for each of the individual rows/casesparameterize start and end dateadd a column with the caseexclude the weekend daysadd the columns start date and end date take sequenquially one row after anotherdata cleaning,rename the columnStart and End date in countriesconvert data type to date and not stringadd the columns that say if it's a holidaydepending on date and countryconvert data type to date and not stringexclude the rows/days that are a holidayadd a column with the countryExcel Reader Row Filter Row Filter Create Date&TimeRange Date&Time to String Rule Engine GroupBy Loop End Table Rowto Variable ConstantValue Column Row Filter Joiner Chunk Loop Start Column Rename CSV Reader String to Date&Time Joiner String to Date&Time Row Filter ConstantValue Column

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: alice.krebs
Created at: 2023-10-24
On NodePit since: 2023-11-14
Last update: 2024-11-14
Created with KNIME version: v4.7.7

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!