Icon

Ajusting Quantities to be ordered to suppliers Minimum ordering quantities

Node 1Get sum bySupplier and MonthGroup by SupplierNode 4MOQAdd theSupplier's MOQinfoNumerical Row IDfor sorting purposesCheck for rowswhere MovingAgg. satisfiesSupplier's MOQGet the first"Row ID"Convert "Row ID"to variableFilter based on the "Row ID"Node 12First Order = "Y"First Order = "N"Node 15Node 16Node 17Node 18Node 19Node 20Node 21Node 22Node 23Table Creator GroupBy Group Loop Start Moving Aggregation Table Creator Joiner Counter Generation Rule-basedRow Filter GroupBy Table Rowto Variable Row Filter Joiner ConstantValue Column ConstantValue Column Concatenate Loop End Rule Engine Column Filter Table Rowto Variable IF Switch GroupBy ConstantValue Column End IF Node 1Get sum bySupplier and MonthGroup by SupplierNode 4MOQAdd theSupplier's MOQinfoNumerical Row IDfor sorting purposesCheck for rowswhere MovingAgg. satisfiesSupplier's MOQGet the first"Row ID"Convert "Row ID"to variableFilter based on the "Row ID"Node 12First Order = "Y"First Order = "N"Node 15Node 16Node 17Node 18Node 19Node 20Node 21Node 22Node 23Table Creator GroupBy Group Loop Start Moving Aggregation Table Creator Joiner Counter Generation Rule-basedRow Filter GroupBy Table Rowto Variable Row Filter Joiner ConstantValue Column ConstantValue Column Concatenate Loop End Rule Engine Column Filter Table Rowto Variable IF Switch GroupBy ConstantValue Column End IF

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: 2022-03-18
On NodePit since: 2022-05-11
Last update: 2024-11-21
Created with KNIME version: v4.5.1

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

Try NodePit Runner!