Icon

Fill in dates between adr

Alternative approach ( benchmark) 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 upNode 14One Iteractionper codeNode 17Node 18Node 19Node 20Node 21Remove unecessary column 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 Create Date&TimeRange Group Loop Start Table Rowto Variable Column Appender Missing Value Loop End Math Formula Column Filter Alternative approach ( benchmark) 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 upNode 14One Iteractionper codeNode 17Node 18Node 19Node 20Node 21Remove unecessary columnExtract 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 Create Date&TimeRange Group Loop Start Table Rowto Variable Column Appender Missing Value Loop End Math Formula 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: 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!