Icon

Filling Columns with dates base on given date

Input dateGenerate datesin month intervalsNode 3Build date basedon given Monthand YearSet months inpast and futureGet start dateConvert builtdate to typeDateGet end dateGenerate numbersto be used asheadersSwitch fromrows to columnsMove generatednumbers asRowIDAdd back thegiven dataNode 14Node 15Table Creator Create Date&TimeRange Table Row ToVariable Loop Start String Manipulation Variable Creator Date&Time Shift String to Date&Time Date&Time Shift Counter Generation Transpose RowID Column Expressions Column Resorter Loop End Input dateGenerate datesin month intervalsNode 3Build date basedon given Monthand YearSet months inpast and futureGet start dateConvert builtdate to typeDateGet end dateGenerate numbersto be used asheadersSwitch fromrows to columnsMove generatednumbers asRowIDAdd back thegiven dataNode 14Node 15Table Creator Create Date&TimeRange Table Row ToVariable Loop Start String Manipulation Variable Creator Date&Time Shift String to Date&Time Date&Time Shift Counter Generation Transpose RowID Column Expressions Column Resorter Loop End

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: bruno
Created at: 2021-11-08
On NodePit since: 2022-02-06
Last update: 2024-04-28
Created with KNIME version: v4.4.2

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

Try NodePit Runner!