Icon

supplierAllocation ks

dummy tablewith line itemsvarThresholdfor S1top: unassignedproductsbottom: alreadyassigned productsaggregatePurchase Pricesplit byvarThresholdtop: products < thresholdbottom: remaining productsDummySupplierstop: product tblbottom: supplierstop: 1st supplier bottom: remainingsupplier'current' Supplieras flow varassign'current' Supplierthrough flow varremove Cumulativ Sumfor next iterationtop: collector assigned productsmiddle: collectorremaining productsbottom: recurse on suppliersassignRequired SuppliertoSelected SupplierremoveCumulative Purchase PricecolumnMerge 'Required Suppliers'with 'Assigned Suppliers'group 'Required'Purchase Price Volumesby Supplierkeep onlySupplierS1Purchase Price(for 'required')deduct 'required volume'from Threshold volumeTESTsumPurchase Priceby Selected Supplierassign S2to the currently'empty' productsJoin iteration 1and 'the rest'Table Creator Double Widget Row Splitter Moving Aggregator Row Splitter Table Creator RecursiveLoop Start Row Splitter Table Rowto Variable ConstantValue Column Column Filter Recursive Loop End Rule Engine Column Filter Concatenate GroupBy Row Filter Table Rowto Variable Math Formula(Variable) GroupBy Rule Engine Concatenate dummy tablewith line itemsvarThresholdfor S1top: unassignedproductsbottom: alreadyassigned productsaggregatePurchase Pricesplit byvarThresholdtop: products < thresholdbottom: remaining productsDummySupplierstop: product tblbottom: supplierstop: 1st supplier bottom: remainingsupplier'current' Supplieras flow varassign'current' Supplierthrough flow varremove Cumulativ Sumfor next iterationtop: collector assigned productsmiddle: collectorremaining productsbottom: recurse on suppliersassignRequired SuppliertoSelected SupplierremoveCumulative Purchase PricecolumnMerge 'Required Suppliers'with 'Assigned Suppliers'group 'Required'Purchase Price Volumesby Supplierkeep onlySupplierS1Purchase Price(for 'required')deduct 'required volume'from Threshold volumeTESTsumPurchase Priceby Selected Supplierassign S2to the currently'empty' productsJoin iteration 1and 'the rest'Table Creator Double Widget Row Splitter Moving Aggregator Row Splitter Table Creator RecursiveLoop Start Row Splitter Table Rowto Variable ConstantValue Column Column Filter Recursive Loop End Rule Engine Column Filter Concatenate GroupBy Row Filter Table Rowto Variable Math Formula(Variable) GroupBy Rule Engine Concatenate

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: marti
Created at: 2024-08-13
On NodePit since: 2024-08-14
Last update: 2024-09-16
Created with KNIME version: v5.2.3

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

Try NodePit Runner!