Icon

Forum - Date Scaffolding - v2

Generate a calendar of all days within date range Read Excel entries for Contracts, and make the data easier to process, by filling in "blank" dates to allow them to be used in comparisons.Turn dates into yyyy-mm-dd strings for easier manipulation and comparison Perform the join lining each contract entry to all calendar dates in which it is active.At the end, sort joined rows into calendar order, and then perform group by to count the contracts that areactive on each calendar date Read Contract Date InfoMissing end of lifeset to 9999-12-31Missing Terminated Dateset to 9999-12-31Missing sold dateset to 9999-12-31Missing suspended start dateset to 9999-12-31(not suspended)Missing unsuspended dateset to 9999-12-31Calendar Date Range2022-01-01to2023-12-31Generate all calendar within the rangeDates asflow varsConvert Dates into stringsto make it easier to work withand use in row-filters etcSort into date orderGet node/componentperformance statsin miliisecondsNode 22Contracts Active by DateInspect a single contract53111Inspect a single contract53111(for testing purposes)join that single contract back to calendarto fill in anycalendar days that the contractwas not active one.g. the one year blockcommencing 2022-04-11All entries for test contractin ascending date orderfind days that each contractis activeOpen File or Folder Excel Reader Rule Engine Rule Engine Rule Engine Rule Engine Rule Engine Table Creator Create Date&TimeRange Table Rowto Variable Date&Time to String Date&Time to String Sorter Timer Info Sorter GroupBy Row Filter Row Filter Joiner Sorter Join CustomCondition - indexed Generate a calendar of all days within date range Read Excel entries for Contracts, and make the data easier to process, by filling in "blank" dates to allow them to be used in comparisons.Turn dates into yyyy-mm-dd strings for easier manipulation and comparison Perform the join lining each contract entry to all calendar dates in which it is active.At the end, sort joined rows into calendar order, and then perform group by to count the contracts that areactive on each calendar date Read Contract Date InfoMissing end of lifeset to 9999-12-31Missing Terminated Dateset to 9999-12-31Missing sold dateset to 9999-12-31Missing suspended start dateset to 9999-12-31(not suspended)Missing unsuspended dateset to 9999-12-31Calendar Date Range2022-01-01to2023-12-31Generate all calendar within the rangeDates asflow varsConvert Dates into stringsto make it easier to work withand use in row-filters etcSort into date orderGet node/componentperformance statsin miliisecondsNode 22Contracts Active by DateInspect a single contract53111Inspect a single contract53111(for testing purposes)join that single contract back to calendarto fill in anycalendar days that the contractwas not active one.g. the one year blockcommencing 2022-04-11All entries for test contractin ascending date orderfind days that each contractis activeOpen File or Folder Excel Reader Rule Engine Rule Engine Rule Engine Rule Engine Rule Engine Table Creator Create Date&TimeRange Table Rowto Variable Date&Time to String Date&Time to String Sorter Timer Info Sorter GroupBy Row Filter Row Filter Joiner Sorter Join CustomCondition - indexed

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: BATEB031
Created at: 2023-06-13
On NodePit since: 2023-06-14
Last update: 2024-04-27
Created with KNIME version: v4.7.4

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

Try NodePit Runner!