Icon

Fill in dates between

Sample DataSet up sample datadata types(make date columns)end date minusstart date(in days)Creates additional rowsforeach dayAdd 1 as we wantone row per dayincluding start and end dates... and make itan integerGet ranking of each"counter" valuegrouped by CODWe need a changingvalue to be countedby the rank nodeso we create one.It doesn't matter what the values areas long as they change per rowsubtract 1 from the ranking as we want thisto be an "offset" starting with zeroAdd rankingto the START_DATEto get our calendardateTidy upTidy upTidy upExtract Data Tablefrom Delimited Text String to Date&Time Date&TimeDifference One Row to Many Math Formula Rank Counter Generation Math Formula Date&Time Shift Column Rename Column Filter RowID Sample DataSet up sample datadata types(make date columns)end date minusstart date(in days)Creates additional rowsforeach dayAdd 1 as we wantone row per dayincluding start and end dates... and make itan integerGet ranking of each"counter" valuegrouped by CODWe need a changingvalue to be countedby the rank nodeso we create one.It doesn't matter what the values areas long as they change per rowsubtract 1 from the ranking as we want thisto be an "offset" starting with zeroAdd rankingto the START_DATEto get our calendardateTidy upTidy upTidy upExtract Data Tablefrom Delimited Text String to Date&Time Date&TimeDifference One Row to Many Math Formula Rank Counter Generation Math Formula Date&Time Shift Column Rename Column Filter RowID

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: bbate
Created at: 2022-10-30
On NodePit since: 2022-10-31
Last update: 2024-04-27
Created with KNIME version: v4.6.3

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

Try NodePit Runner!