Icon

Loop Test_​2

end chunk loopTransactions are sortedper DATE and MARKETTake all records organizedin groups ofMarketNow we have a group of recrodsEach record must be taken separatly a) SELL records will add amount value to FVamntSold b) BUY records will substract amountvalue from FVamntSoldset FVamntSoldThis variable will hold amount sold throughout the CHUNK LOOP (inner loop)This variable is calculated and should resetonly in the outer loop (The group loop)Calculate remainingamount Bought based onpreviously sold Amountend Group loopNode 226Node 227Buy * -1Node 229Transactions are sortedper DATE and MARKETTake all records organizedin groups ofMarketNode 232Node 233Loop End Sorter Group Loop Start Chunk Loop Start VariableExpressions Java Snippet Loop End Excel Reader (XLS) Row Splitter Math Formula Concatenate Sorter Group Loop Start Moving Aggregation Loop End end chunk loopTransactions are sortedper DATE and MARKETTake all records organizedin groups ofMarketNow we have a group of recrodsEach record must be taken separatly a) SELL records will add amount value to FVamntSold b) BUY records will substract amountvalue from FVamntSoldset FVamntSoldThis variable will hold amount sold throughout the CHUNK LOOP (inner loop)This variable is calculated and should resetonly in the outer loop (The group loop)Calculate remainingamount Bought based onpreviously sold Amountend Group loopNode 226Node 227Buy * -1Node 229Transactions are sortedper DATE and MARKETTake all records organizedin groups ofMarketNode 232Node 233Loop End Sorter Group Loop Start Chunk Loop Start VariableExpressions Java Snippet Loop End Excel Reader (XLS) Row Splitter Math Formula Concatenate Sorter Group Loop Start Moving Aggregation 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: hiyanzoubi
Created at: 2020-08-29
On NodePit since: 2022-02-06
Last update: 2024-11-24
Created with KNIME version: v4.2.0

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

Try NodePit Runner!