Icon

summing up the quantities to be ordered

"normal" nodes optimised flow using scripting nodes Node Golf sampleinputcastdaterenamedesired outputloop overproductsloop overmonthsappend columnorder amountappend columnoverflowlagoverflowNode 9single outcurrent monthcalcorder amountcalcoverflowreunitetableexcludelagged overflowloop endmonthsNode 16empty tableto stop loophelpernodeloop endproductsloop overproductsNode 21loop endproducts=)fix inputorderinputtablesupplierinfosum itemsmonth+supplierjoinINNER1. supplier ASC2. month ASCallocateindex to orderjoinINNERsum itemsproduct+indexjoinLEFTNode 341. supplier ASC2. month ASCNode 36calcpallets_tbocalcactualOrder_palletsNode 39Node 40 Excel Reader String to Date&Time Column Rename Group Loop Start RecursiveLoop Start ConstantValue Column ConstantValue Column Lag Column Missing Value Row Splitter Math Formula Math Formula Concatenate Column Filter Recursive Loop End Sorter Rule-basedRow Filter Math Formula(Variable) Loop End Group Loop Start Java Snippet Loop End Java Snippet Sorter Table Creator Table Creator GroupBy Joiner Sorter Java Snippet Joiner GroupBy Joiner Column Rename Sorter Missing Value Math Formula Math Formula Column Resorter Column Filter "normal" nodes optimised flow using scripting nodes Node Golf sampleinputcastdaterenamedesired outputloop overproductsloop overmonthsappend columnorder amountappend columnoverflowlagoverflowNode 9single outcurrent monthcalcorder amountcalcoverflowreunitetableexcludelagged overflowloop endmonthsNode 16empty tableto stop loophelpernodeloop endproductsloop overproductsNode 21loop endproducts=)fix inputorderinputtablesupplierinfosum itemsmonth+supplierjoinINNER1. supplier ASC2. month ASCallocateindex to orderjoinINNERsum itemsproduct+indexjoinLEFTNode 341. supplier ASC2. month ASCNode 36calcpallets_tbocalcactualOrder_palletsNode 39Node 40 Excel Reader String to Date&Time Column Rename Group Loop Start RecursiveLoop Start ConstantValue Column ConstantValue Column Lag Column Missing Value Row Splitter Math Formula Math Formula Concatenate Column Filter Recursive Loop End Sorter Rule-basedRow Filter Math Formula(Variable) Loop End Group Loop Start Java Snippet Loop End Java Snippet Sorter Table Creator Table Creator GroupBy Joiner Sorter Java Snippet Joiner GroupBy Joiner Column Rename Sorter Missing Value Math Formula Math Formula Column Resorter 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: JohannesHolzschuh
Created at: 2022-04-05
On NodePit since: 2022-04-14
Last update: 2024-04-27
Created with KNIME version: v4.5.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!