Icon

kn_​forum_​26380_​loop_​send_​calculated_​data_​back

If you just want to initiate / reset the FVamntSold variableattach it to the inner loop start 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 226FVamntSold=> initialize tthe ttable with tthe valueFVamntSold => 0.0FVamntSold.tableFVamntSold.tableNode 230FVamntSold to table rowFVamntSold.tablestore the current value in a tablejust a node to attachthe Flow Variable to Loop End Sorter Group Loop Start Chunk Loop Start VariableExpressions Java Snippet Loop End Excel Reader (XLS) Table Creator Table Writer Table Reader Table Rowto Variable Variable toTable Row Table Writer Column Filter If you just want to initiate / reset the FVamntSold variableattach it to the inner loop start 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 226FVamntSold=> initialize tthe ttable with tthe valueFVamntSold => 0.0FVamntSold.tableFVamntSold.tableNode 230FVamntSold to table rowFVamntSold.tablestore the current value in a tablejust a node to attachthe Flow Variable toLoop End Sorter Group Loop Start Chunk Loop Start VariableExpressions Java Snippet Loop End Excel Reader (XLS) Table Creator Table Writer Table Reader Table Rowto Variable Variable toTable Row Table Writer Column Filter

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.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!