Icon

KNIME_​projectdwq

This part is to adjust demand. Example if on the 12th I have demand and on the 13th I don't have it, itmust be combined with the 12th.This Flow is running and working This flow is running but has an error.Here I need to calculate the BACKLOG. Node 1 mark 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 blockiterate througheach groupbased on origin-destinyiterate allorig-dest groupsNode 22Node 24Node 33Node 281add to first row(original last calc row)sort ascending block numberagain to put backin original orderNode 663sum of shippingfor "missing"rowssort desc block numberso row to be updated is first roweasily debug a specific groupby filtering it herefinal "missing" rowsfor the currentgroupgo to lower portMark calculated column as zerowhere the Receiving Capacitywas missingNode 1121reattach the split-off rowsNode 1123Node 1124Node 1125Node 1126Node 1127Node 1128Node 1129Node 1130Node 1131Table Creator Mark Blocksin Table Missing Value Cumulative Sumfor Grouping Group Loop Start Loop End Extract Date&TimeFields Column Expressions Moving Aggregation Java Snippet Math Formula Sorter Sorter Table Rowto Variable GroupBy Sorter Row Filter Row Splitter Rule Engine Sorter Concatenate String to Date&Time Rank Double To Int Counter Generation Column Filter Row Filter Rule Engine Column Filter String To Number This part is to adjust demand. Example if on the 12th I have demand and on the 13th I don't have it, itmust be combined with the 12th.This Flow is running and working This flow is running but has an error.Here I need to calculate the BACKLOG. Node 1 mark 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 blockiterate througheach groupbased on origin-destinyiterate allorig-dest groupsNode 22Node 24Node 33Node 281add to first row(original last calc row)sort ascending block numberagain to put backin original orderNode 663sum of shippingfor "missing"rowssort desc block numberso row to be updated is first roweasily debug a specific groupby filtering it herefinal "missing" rowsfor the currentgroupgo to lower portMark calculated column as zerowhere the Receiving Capacitywas missingNode 1121reattach the split-off rowsNode 1123Node 1124Node 1125Node 1126Node 1127Node 1128Node 1129Node 1130Node 1131Table Creator Mark Blocksin Table Missing Value Cumulative Sumfor Grouping Group Loop Start Loop End Extract Date&TimeFields Column Expressions Moving Aggregation Java Snippet Math Formula Sorter Sorter Table Rowto Variable GroupBy Sorter Row Filter Row Splitter Rule Engine Sorter Concatenate String to Date&Time Rank Double To Int Counter Generation Column Filter Row Filter Rule Engine Column Filter String To Number

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-24
On NodePit since: 2023-10-25
Last update: 2024-09-16
Created with KNIME version: v4.7.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!