Icon

Cumulative Calc Shipping

Get sum of blocks with missing block number as these have no "next day" and add them onto the calc for the last "known" day Sample dataCorrect data typesand "?" become missingmark a block wherethere is a numeric valuein Receiving CapacityWhere a block hasn't beenmarked, set it to the number of the followingblockcumulative some of Shipping Volumefor each blockMark calculated column as zerowhere the Receiving Capacitywas missingiterate througheach groupbased on origin-destinyiterate allorig-dest groupseasily debug a specific groupby filtering it herefinal "missing" rowsfor the currentgroupgo to lower portsum of shippingfor "missing"rowssort desc block numberso row to be updated is first rowadd to first row(original last calc row)sort ascending block numberagain to put backin original orderreattach the split-off rowsTable Creator String To Number Mark Blocksin Table Missing Value Cumulative Sumfor Grouping Rule Engine Group Loop Start Loop End Row Filter Row Splitter GroupBy Sorter Table Rowto Variable Math Formula Sorter Concatenate Get sum of blocks with missing block number as these have no "next day" and add them onto the calc for the last "known" day Sample dataCorrect data typesand "?" become missingmark a block wherethere is a numeric valuein Receiving CapacityWhere a block hasn't beenmarked, set it to the number of the followingblockcumulative some of Shipping Volumefor each blockMark calculated column as zerowhere the Receiving Capacitywas missingiterate througheach groupbased on origin-destinyiterate allorig-dest groupseasily debug a specific groupby filtering it herefinal "missing" rowsfor the currentgroupgo to lower portsum of shippingfor "missing"rowssort desc block numberso row to be updated is first rowadd to first row(original last calc row)sort ascending block numberagain to put backin original orderreattach the split-off rowsTable Creator String To Number Mark Blocksin Table Missing Value Cumulative Sumfor Grouping Rule Engine Group Loop Start Loop End Row Filter Row Splitter GroupBy Sorter Table Rowto Variable Math Formula Sorter 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: gabriel.mattos
Created at: 2023-10-09
On NodePit since: 2023-10-13
Last update: 2024-04-27
Created with KNIME version: v4.7.7

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

Try NodePit Runner!