Icon

Subtotal_​v2

Groupby ID,Month, Year, DayCalculateCumulativeSUMCUMULATIVE_AMOUNTIDYEARMONTHDAYTIMEAMOUNT$CUMULATIVE_AMOUNT$ < 20000 => TRUETop input goes to the Loop End nodeBottom input goes back to the start for processingIf value in CUMULATIVE_AMOUNTis less than the max value of that column, add 1 to a new column called Flagremove CUMULATIVE_AMOUNTcolumn before next iterationcalculate maxvalue inCUMULATIVE_AMOUNTcolumnNode 36Group Loop Start Moving Aggregation Column Rename GenerateRandom Data Rule-basedRow Splitter RecursiveLoop Start Recursive Loop End Rule Engine Column Filter Math Formula Loop End Groupby ID,Month, Year, DayCalculateCumulativeSUMCUMULATIVE_AMOUNTIDYEARMONTHDAYTIMEAMOUNT$CUMULATIVE_AMOUNT$ < 20000 => TRUETop input goes to the Loop End nodeBottom input goes back to the start for processingIf value in CUMULATIVE_AMOUNTis less than the max value of that column, add 1 to a new column called Flagremove CUMULATIVE_AMOUNTcolumn before next iterationcalculate maxvalue inCUMULATIVE_AMOUNTcolumnNode 36Group Loop Start Moving Aggregation Column Rename GenerateRandom Data Rule-basedRow Splitter RecursiveLoop Start Recursive Loop End Rule Engine Column Filter Math Formula Loop End

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: Mauricio
Created at: 2020-05-09
On NodePit since: 2020-05-10
Last update: 2024-11-23
Created with KNIME version: v4.1.2

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

Try NodePit Runner!