Icon

Row calculation based on multiple columns

Start value =! 0 only with first row per item Alternative 1 Alternative 1 DataItem ascendingYear ascendingCW ascendingCompute:Initial stockFinal stockFor every itemRows and colsOnly rownumberFor each rowGet finalvalueSelect untilrow iFor each rowTake last columnonlyFor every item Excel Reader Sorter R Snippet Group Loop Start Extract TableDimension Transpose Table Rowto Variable Counting Loop Start Math Formula Row Filter Loop End Top k Selector Loop End Start value =! 0 only with first row per item Alternative 1 Alternative 1 DataItem ascendingYear ascendingCW ascendingCompute:Initial stockFinal stockFor every itemRows and colsOnly rownumberFor each rowGet finalvalueSelect untilrow iFor each rowTake last columnonlyFor every itemExcel Reader Sorter R Snippet Group Loop Start Extract TableDimension Transpose Table Rowto Variable Counting Loop Start Math Formula Row Filter Loop End Top k Selector 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: rbarri
Created at: 2023-01-31
On NodePit since: 2023-02-02
Last update: 2024-11-21
Created with KNIME version: v4.7.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!