Icon

Loop Test

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 226Loop End Sorter Group Loop Start Chunk Loop Start VariableExpressions Java Snippet Loop End Excel Reader (XLS) 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 226Loop End Sorter Group Loop Start Chunk Loop Start VariableExpressions Java Snippet Loop End Excel Reader (XLS)

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-05-01
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!