Icon

zero down value

Your column should be in order Jan, Feb, Mar, ..., DecNow I add +7 in the nodeWhen you start wit Jan: +1 inputloop every monthextract motnthvalid toextract monthvalid fromcurrent iteration +7=> Julytidy upbase columns Table Creator String to Date&Time Column ListLoop Start Extract Date&TimeFields Extract Date&TimeFields Math Formula(Variable) Column Rename Column Rename Rule Engine Column Rename Loop End (ColumnAppend) Column Filter Column Filter Column Appender Your column should be in order Jan, Feb, Mar, ..., DecNow I add +7 in the nodeWhen you start wit Jan: +1 inputloop every monthextract motnthvalid toextract monthvalid fromcurrent iteration +7=> Julytidy upbase columnsTable Creator String to Date&Time Column ListLoop Start Extract Date&TimeFields Extract Date&TimeFields Math Formula(Variable) Column Rename Column Rename Rule Engine Column Rename Loop End (ColumnAppend) Column Filter Column Filter Column Appender

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: Karlygash_Mukhitova
Created at: 2021-08-14
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.4.0

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

Try NodePit Runner!