Icon

Dynamic column pairs calculation

Node 1Node 8Node 11Remove thefirst yearKeep onlythe columnnamesNode 14Assign columnnames tovariablesSort the restof the columnsso we canignore thefirst yearTemporarily renamecolumns to somefixed name sowe an use themin the Math FormulaNode 18Rename backthe columnsNode 20Filter out columnsthat are not partof the Growth calculationssuch as the first column(Row Name)Tidy upTable Creator Column Expressions Extract Table Spec Row Filter Column Filter Table Row ToVariable Loop Start VariableExpressions Sorter Column Rename Math Formula Column Rename Loop End (ColumnAppend) Row Filter Column Filter Node 1Node 8Node 11Remove thefirst yearKeep onlythe columnnamesNode 14Assign columnnames tovariablesSort the restof the columnsso we canignore thefirst yearTemporarily renamecolumns to somefixed name sowe an use themin the Math FormulaNode 18Rename backthe columnsNode 20Filter out columnsthat are not partof the Growth calculationssuch as the first column(Row Name)Tidy upTable Creator Column Expressions Extract Table Spec Row Filter Column Filter Table Row ToVariable Loop Start VariableExpressions Sorter Column Rename Math Formula Column Rename Loop End (ColumnAppend) Row Filter 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: bruno
Created at: 2021-09-02
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.4.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!