Icon

Calculate PLT Cube V2

Method A: Calculate Pallet per order Method B: Calculate Pallet per order input dataCalculateTotal CubeCalculateOrderLine CubeCalculatePallet IDCube Per Pallet IDNext rowTake outlast columnNode 12Go line by lineDuplicaterowNextduplicateAssign Single QTYCalculateTotal CubeCalculateCase IDCube Per Pallet IDPallet CubePallets Greaterthan Pallet CubeNode 290create as manyrows as Order_QTYevery rowcurrent SKUnew data setcollec resultsCumulatiive sum Cubetop = palet max 45add pallet IDremoveCumulatiive sum Cubecount palletsize Table Creator Moving Aggregator Math Formula Math Formula GroupBy Loop End(deprecated) Column Filter Table Row to Variable(deprecated) Chunk Loop Start Counting Loop Start(deprecated) Loop End(deprecated) ConstantValue Column Moving Aggregator Math Formula GroupBy Variable Creator Rule-basedRow Splitter Rule-basedRow Splitter One Row to Many Table Row toVariable Loop Start Row Filter Loop End RecursiveLoop Start Recursive Loop End Moving Aggregator Row Splitter ConstantValue Column Column Filter GroupBy Method A: Calculate Pallet per order Method B: Calculate Pallet per order input dataCalculateTotal CubeCalculateOrderLine CubeCalculatePallet IDCube Per Pallet IDNext rowTake outlast columnNode 12Go line by lineDuplicaterowNextduplicateAssign Single QTYCalculateTotal CubeCalculateCase IDCube Per Pallet IDPallet CubePallets Greaterthan Pallet CubeNode 290create as manyrows as Order_QTYevery rowcurrent SKUnew data setcollec resultsCumulatiive sum Cubetop = palet max 45add pallet IDremoveCumulatiive sum Cubecount palletsizeTable Creator Moving Aggregator Math Formula Math Formula GroupBy Loop End(deprecated) Column Filter Table Row to Variable(deprecated) Chunk Loop Start Counting Loop Start(deprecated) Loop End(deprecated) ConstantValue Column Moving Aggregator Math Formula GroupBy Variable Creator Rule-basedRow Splitter Rule-basedRow Splitter One Row to Many Table Row toVariable Loop Start Row Filter Loop End RecursiveLoop Start Recursive Loop End Moving Aggregator Row Splitter ConstantValue Column Column Filter GroupBy

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: A0057902
Created at: 2024-05-01
On NodePit since: 2024-05-02
Last update: 2024-05-18
Created with KNIME version: v5.2.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!