Icon

Only positive moving aggregation

Method 1: Line by line Method 2: Recursive loop DataRead lineby lineDo the cumulativeaggregation, andapply rule if thecumulatie aggregation< 0, then replace with 0Node 10Initialize lastcum status to 0Update last cumstatus to be usedin next iterationConvert the cumagg to variableNode 15Generate IDfor each lineRename toLineIDNode 19Get the <0Get the LineIDof the first <0Save it asa variableSet the agg forthe LineIDto 0Remove aggcolumn to goback into the loopNode 26Clean upSeparatethe "good" (top)from the"bad" (bottom) Table Creator Chunk Loop Start Math Formula Loop End Variable Creator VariableExpressions Table Rowto Variable Moving Aggregation Counter Generation Column Rename RecursiveLoop Start Row Filter GroupBy Table Rowto Variable Rule Engine Column Filter Recursive Loop End Column Filter Rule-basedRow Splitter Method 1: Line by line Method 2: Recursive loop DataRead lineby lineDo the cumulativeaggregation, andapply rule if thecumulatie aggregation< 0, then replace with 0Node 10Initialize lastcum status to 0Update last cumstatus to be usedin next iterationConvert the cumagg to variableNode 15Generate IDfor each lineRename toLineIDNode 19Get the <0Get the LineIDof the first <0Save it asa variableSet the agg forthe LineIDto 0Remove aggcolumn to goback into the loopNode 26Clean upSeparatethe "good" (top)from the"bad" (bottom) Table Creator Chunk Loop Start Math Formula Loop End Variable Creator VariableExpressions Table Rowto Variable Moving Aggregation Counter Generation Column Rename RecursiveLoop Start Row Filter GroupBy Table Rowto Variable Rule Engine Column Filter Recursive Loop End Column Filter Rule-basedRow Splitter

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: bruno
Created at: 2021-10-16
On NodePit since: 2022-02-06
Last update: 2024-04-28
Created with KNIME version: v4.4.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!