Icon

Fill in dates between- primarykey

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"PrimaryKey"We 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 upCreate a new "unique key"Call it "PrimaryKey"Extract 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 Counter Generation Column Rename 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"PrimaryKey"We 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 upCreate a new "unique key"Call it "PrimaryKey"Extract 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 Counter Generation Column Rename

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!