Icon

sum between flagged rows

iteration0: using Java Snippet for lack of better idea iteration1: using non-scripting nodes (not recommended, but safe to use) sampledatafindstart/endremoveP rowsbetween groupstop: Ebottom: restsumcolumn2joinLEFTNode 7optionallyremove sumsof non-E rowssampledatamarkstart and endfillremaining rowsremoveend valuesremoveP rowsbetween groupstop: Ebottom: restsumcolumn2joinLEFToptionallyremove sumsof non-E rowsNode 20empty output--> same tablefillend values Table Creator Java Snippet Row Filter Row Splitter GroupBy Joiner Column Rename Rule Engine Table Creator Rule Engine Missing Value Rule Engine Row Filter Row Splitter GroupBy Joiner Rule Engine Column Rename Table DifferenceFinder Missing Value iteration0: using Java Snippet for lack of better idea iteration1: using non-scripting nodes (not recommended, but safe to use) sampledatafindstart/endremoveP rowsbetween groupstop: Ebottom: restsumcolumn2joinLEFTNode 7optionallyremove sumsof non-E rowssampledatamarkstart and endfillremaining rowsremoveend valuesremoveP rowsbetween groupstop: Ebottom: restsumcolumn2joinLEFToptionallyremove sumsof non-E rowsNode 20empty output--> same tablefillend valuesTable Creator Java Snippet Row Filter Row Splitter GroupBy Joiner Column Rename Rule Engine Table Creator Rule Engine Missing Value Rule Engine Row Filter Row Splitter GroupBy Joiner Rule Engine Column Rename Table DifferenceFinder Missing Value

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: JohannesHolzschuh
Created at: 2022-02-16
On NodePit since: 2022-02-22
Last update: 2024-04-27
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!