Icon

Forecast_​loop_​v0.1.2

Recursive Loop End:Input port 0: Collect result rows for each iterationInput port 1: The remaining result set for the next iterationInput port 2: Initial value for the next iterationOut port 0: Result set collected on input port 0 Node 1428Node 1434Node 1437Node 1442Node 1444Node 1447Node 1450Node 1452growthemissiontop: Recurrent tablebottom: Initial value tableNode 1456growthemissiontop: The first row of the current tablebottom: Remaining rows in the current tableMerge initial values with current calculation rowscalCalculate columns (only one row and one column)Change the column name and invest it in the next iteration calculationinitial_emissionsRecurrent table2024-05-24_growth by group.xlsx Initial value table2024-05-24_emissions by group.xlsxgroup by "group 2"Merge initial values with current calculation rowsCalculate columns (only one row and one column)top: The first row of the current tablebottom: Remaining rows in the current tabletop: Recurrent tablebottom: Initial value tableFilter using the current groupTransform multiple lines into one lineNode 1492Change the column name and invest it in the next iteration calculationint -> double Table Row toVariable Loop Start Table Rowto Variable Variable toTable Row Column Expressions Variable Loop End Table Rowto Variable VariableExpressions Column Expressions Table Creator Table Creator RecursiveLoop Start Recursive Loop End Table Creator Table Creator Row Splitter Column Appender Math Formula Column Filter Column Renamer Column Filter Excel Reader Excel Reader Group Loop Start Column Appender Column Filter Row Splitter RecursiveLoop Start Recursive Loop End Row Filter Pivot Column Filter Math Formula(Multi Column) Column Rename(Regex) Math Formula(Multi Column) Loop End Recursive Loop End:Input port 0: Collect result rows for each iterationInput port 1: The remaining result set for the next iterationInput port 2: Initial value for the next iterationOut port 0: Result set collected on input port 0 Node 1428Node 1434Node 1437Node 1442Node 1444Node 1447Node 1450Node 1452growthemissiontop: Recurrent tablebottom: Initial value tableNode 1456growthemissiontop: The first row of the current tablebottom: Remaining rows in the current tableMerge initial values with current calculation rowscalCalculate columns (only one row and one column)Change the column name and invest it in the next iteration calculationinitial_emissionsRecurrent table2024-05-24_growth by group.xlsx Initial value table2024-05-24_emissions by group.xlsxgroup by "group 2"Merge initial values with current calculation rowsCalculate columns (only one row and one column)top: The first row of the current tablebottom: Remaining rows in the current tabletop: Recurrent tablebottom: Initial value tableFilter using the current groupTransform multiple lines into one lineNode 1492Change the column name and invest it in the next iteration calculationint -> double Table Row toVariable Loop Start Table Rowto Variable Variable toTable Row Column Expressions Variable Loop End Table Rowto Variable VariableExpressions Column Expressions Table Creator Table Creator RecursiveLoop Start Recursive Loop End Table Creator Table Creator Row Splitter Column Appender Math Formula Column Filter Column Renamer Column Filter Excel Reader Excel Reader Group Loop Start Column Appender Column Filter Row Splitter RecursiveLoop Start Recursive Loop End Row Filter Pivot Column Filter Math Formula(Multi Column) Column Rename(Regex) Math Formula(Multi Column) 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: schilmai
Created at: 2024-05-24
On NodePit since: 2024-05-25
Last update: 2024-11-21
Created with KNIME version: v5.2.4

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!