Icon

Forum- Apply column value to date columns

Applies values to columns based on column name, and date ranges


@takbb Brian Bates 18 Jan 2023

execute to view workflow data folderSampleData.xlsxloop through the period columnsCurrent columnMonthStartforward 1 month(start of next month)Back 1 day(to end of current month)MonthEndDecide if the monthly valueis for the current periodcolumnPut this back into variablesCollect the single current columnfor each iterationKeep onlycurrent column(ie the month column)Bring columns back togetherRemove the "Month" columnsas they will be replacedby lower branchBuild string for 1st of monthOutput new spreadsheetOpen File or Folder Excel Reader Column ListLoop Start Variable toTable Row String to Date&Time Date&Time Shift Date&Time Shift Column Rename Rule Engine Table Rowto Variable Loop End (ColumnAppend) Column Filter Column Appender Column Filter String Manipulation Excel Writer execute to view workflow data folderSampleData.xlsxloop through the period columnsCurrent columnMonthStartforward 1 month(start of next month)Back 1 day(to end of current month)MonthEndDecide if the monthly valueis for the current periodcolumnPut this back into variablesCollect the single current columnfor each iterationKeep onlycurrent column(ie the month column)Bring columns back togetherRemove the "Month" columnsas they will be replacedby lower branchBuild string for 1st of monthOutput new spreadsheetOpen File or Folder Excel Reader Column ListLoop Start Variable toTable Row String to Date&Time Date&Time Shift Date&Time Shift Column Rename Rule Engine Table Rowto Variable Loop End (ColumnAppend) Column Filter Column Appender Column Filter String Manipulation Excel Writer

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-01-18
On NodePit since: 2023-01-19
Last update: 2024-04-27
Created with KNIME version: v4.6.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!