Icon

remove non-business days

Remove Non-Business Days

The following is an example of how to remove days that aren't working days. In this workflow we first remove the dates which are on the last two days of the week and then use an API (https://date.nager.at/) to fetch the public holidays of the selected country and filter those out as well. Not all countries are contained, since the public holiday API being used is not complete.

Remove Non-Business DaysThe following is an example of how to remove days that aren't working days. In this workflow we first remove the dates which are on the last two days of theweek and then use an API (https://date.nager.at/) to fetch the public holidays of the selected country and filter those out as well. Not all countries arecontained, since the public holiday API being used is not complete. inputget weekdayfilter out weekendsoutputNode 25remove helper column Create Date&TimeRange Extract Date&TimeFields Row Filter Table Writer Public Holiday List ReferenceRow Filter Column Filter Remove Non-Business DaysThe following is an example of how to remove days that aren't working days. In this workflow we first remove the dates which are on the last two days of theweek and then use an API (https://date.nager.at/) to fetch the public holidays of the selected country and filter those out as well. Not all countries arecontained, since the public holiday API being used is not complete. inputget weekdayfilter out weekendsoutputNode 25remove helper column Create Date&TimeRange Extract Date&TimeFields Row Filter Table Writer Public Holiday List ReferenceRow Filter Column Filter

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: karenabraham
Created at: 2022-07-05
On NodePit since: 2022-07-06
Last update: 2024-05-02
Created with KNIME version: v4.5.2
Tags: business daysdatesfilterholidaysweekendssaturdaysunday

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

Try NodePit Runner!