Icon

Loop through a table and re-use calculated values

InputAdd as firstrowChange valuesto negative sinceit's a sum ofnegative valuesAdd 65 as firstrow in Column2ApplyaggregationShift resultsby 1 rowRemove firstrow of 65that wasaddedRename finalresult ascolumn1Tidy upSort thecolumnsConvert backthe negativevalues to positiveTable Creator Table Creator Math Formula Concatenate Moving Aggregation Lag Column Row Filter Column Rename Column Filter Column Resorter Math Formula InputAdd as firstrowChange valuesto negative sinceit's a sum ofnegative valuesAdd 65 as firstrow in Column2ApplyaggregationShift resultsby 1 rowRemove firstrow of 65that wasaddedRename finalresult ascolumn1Tidy upSort thecolumnsConvert backthe negativevalues to positiveTable Creator Table Creator Math Formula Concatenate Moving Aggregation Lag Column Row Filter Column Rename Column Filter Column Resorter Math Formula

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: bruno
Created at: 2022-08-29
On NodePit since: 2022-08-29
Last update: 2024-04-27
Created with KNIME version: v4.5.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!