Icon

JKI Season 2 - Challenge 04 - Spread Yearly Values Across Months - kowisoft

There has been no description set for this workflow's metadata.

Attention: The nodes in this annotation have only been exported so they can be reviewed on the KNIME Hub. Please delete this annotation and all nodes before execution of the complete workflow to not slow down its performance. You can configure the component through right-clickingand selecting ConfigureYou can select by how many months you and quartersyou want to divideAdditionally, all output ports have been labeledaccordingly import 2022_projectstop -> area abottom -> area bsplit monthstop -> ALL expmiddle -> quartely expbottom -> monthly expadd divisorcoldivide overall expby divisorassign monthnumberskeep only rank> current divisoroverwrite month numbersdelete month numbers> divisorassignMonth Namebased onMonth Numberadd divisorcoldivide overall expby divisorassign monthnumberssplit monthsdelete month numbers> divisorassignMonth Namebased onMonth Numberkeep only rank> current divisoroverwrite month numberstidy uptablevar-months-divisoradd 1 to var-months-divisorvar-months-divisoradd 1 to var-months-divisorTable Reader Row Splitter One Row to Many Split Rows by Area ConstantValue Column Math Formula Rank Row Filter Math Formula Concatenate Row Filter Rule Engine ConstantValue Column Math Formula Rank One Row to Many Concatenate Row Filter Rule Engine Row Filter Math Formula Concatenate Table Manipulator IntegerConfiguration Math Formula(Variable) IntegerConfiguration Math Formula(Variable) Attention: The nodes in this annotation have only been exported so they can be reviewed on the KNIME Hub. Please delete this annotation and all nodes before execution of the complete workflow to not slow down its performance. You can configure the component through right-clickingand selecting ConfigureYou can select by how many months you and quartersyou want to divideAdditionally, all output ports have been labeledaccordingly import 2022_projectstop -> area abottom -> area bsplit monthstop -> ALL expmiddle -> quartely expbottom -> monthly expadd divisorcoldivide overall expby divisorassign monthnumberskeep only rank> current divisoroverwrite month numbersdelete month numbers> divisorassignMonth Namebased onMonth Numberadd divisorcoldivide overall expby divisorassign monthnumberssplit monthsdelete month numbers> divisorassignMonth Namebased onMonth Numberkeep only rank> current divisoroverwrite month numberstidy uptablevar-months-divisoradd 1 to var-months-divisorvar-months-divisoradd 1 to var-months-divisorTable Reader Row Splitter One Row to Many Split Rows by Area ConstantValue Column Math Formula Rank Row Filter Math Formula Concatenate Row Filter Rule Engine ConstantValue Column Math Formula Rank One Row to Many Concatenate Row Filter Rule Engine Row Filter Math Formula Concatenate Table Manipulator IntegerConfiguration Math Formula(Variable) IntegerConfiguration Math Formula(Variable)

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: m1pegv
Created at: 2023-04-20
On NodePit since: 2023-04-20
Last update: 2024-11-23
Created with KNIME version: v4.6.4
Tags: JKISeason2-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!