Icon

2019_​11_​26_​Counting_​Target_​Date

Counting Target Date
Counting Target DateThis workflow calculates tagret date from input data which contains date and number of working days to desired target date.Bottom branch creates database of dates excluding weekends and public Holidays with addition of assigning unique ID to everyremaining date. Then using Cell Replacer node and Math Formula new target date is fetched from database.Forum link: https://forum.knime.com/t/date-time-shift-skip-weekends-and-count-public-holidays/19683 Read Croatia Holidays for 2018 and 2019Transform it to dateDB DatesAssing unique ID to every working dayGet week daysFilter out weekend daysAdd DateIDCount ID of Target dateAdd TargetDateInput DataRename Counter columnFilter out HolidaysFile Reader String to Date&Time Create Date&TimeRange Counter Generation Extract Date&TimeFields Rule-basedRow Filter Cell Replacer Math Formula Cell Replacer Table Creator Column Rename ReferenceRow Filter Counting Target DateThis workflow calculates tagret date from input data which contains date and number of working days to desired target date.Bottom branch creates database of dates excluding weekends and public Holidays with addition of assigning unique ID to everyremaining date. Then using Cell Replacer node and Math Formula new target date is fetched from database.Forum link: https://forum.knime.com/t/date-time-shift-skip-weekends-and-count-public-holidays/19683 Read Croatia Holidays for 2018 and 2019Transform it to dateDB DatesAssing unique ID to every working dayGet week daysFilter out weekend daysAdd DateIDCount ID of Target dateAdd TargetDateInput DataRename Counter columnFilter out HolidaysFile Reader String to Date&Time Create Date&TimeRange Counter Generation Extract Date&TimeFields Rule-basedRow Filter Cell Replacer Math Formula Cell Replacer Table Creator Column Rename ReferenceRow 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: Johnny
Created at: 2019-01-03
On NodePit since: 2019-11-27
Last update: 2024-04-28
Created with KNIME version: v4.0.2
Tags: Date Manipulation

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

Try NodePit Runner!