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