Icon

Data Wrangling _​ Recursive Equation

Data Wrangling _ Recursive Equation

Data Wrangling _ Recursive Equation

Workflow created for the KNIME forum ...

https://forum.knime.com/t/time-series-forecasting-with-differenced-series/42152

DESCRIPTION:
The challenge ...


For any comment or bug realted to the workflow, please do not hesitate to leave your comment.

DISCLAIMER:
The sharing of knowledge in KNIME Hub by using these examples and models, have only demonstration purposes in the advantage of the KNIME community.
These are meant to clarify theoretical background of mentioned subjects in caption.
I will not be held responsibility for any damages arising from the use of these models in your investment/valuation related work, without taking formal advise.

KNIME Forum challenge: https://forum.knime.com/t/time-series-forecasting-with-differenced-series/42152Time Series Forecasting with differenced series: Challenge Provided DataSplitt 2000Q4[start reference]... to Variable2000Q4[start reference]Rank TIME ColumnSplittUpper: Rank = 1 [ to Data Collect port ]Lower: Rank <> 1 (>1) [ to pass back port ]INNER JOIN rank == 1with EquationResultsINNER JOIN rank > 1rank$rank$ - 1Max*(rank)... to Variable(cotrol Loop Iterations)Step Column $Forecasted GDP (-1)$Forecasted Original _ CHALLENGEAssign Current Recursive$Forecasted Original _ CHALLENGE(-1)$to next month position [rank == 2]$Forecasted GDP (-1)$LagForecasted Original _ CHALLENGE(-1)Clean UpRecursively Loops overReturned 'Passed Back' DataCollect only last iteration from first in-portSecond in-port is passed back to the loop start Table Creator Row Splitter Table Rowto Variable Column Rename Rank Row Splitter Joiner Joiner Math Formula GroupBy Table Rowto Variable Rule Engine Math Formula Rule Engine Lag Column Column Filter RecursiveLoop Start Recursive Loop End KNIME Forum challenge: https://forum.knime.com/t/time-series-forecasting-with-differenced-series/42152Time Series Forecasting with differenced series: Challenge Provided DataSplitt 2000Q4[start reference]... to Variable2000Q4[start reference]Rank TIME ColumnSplittUpper: Rank = 1 [ to Data Collect port ]Lower: Rank <> 1 (>1) [ to pass back port ]INNER JOIN rank == 1with EquationResultsINNER JOIN rank > 1rank$rank$ - 1Max*(rank)... to Variable(cotrol Loop Iterations)Step Column $Forecasted GDP (-1)$Forecasted Original _ CHALLENGEAssign Current Recursive$Forecasted Original _ CHALLENGE(-1)$to next month position [rank == 2]$Forecasted GDP (-1)$LagForecasted Original _ CHALLENGE(-1)Clean UpRecursively Loops overReturned 'Passed Back' DataCollect only last iteration from first in-portSecond in-port is passed back to the loop start Table Creator Row Splitter Table Rowto Variable Column Rename Rank Row Splitter Joiner Joiner Math Formula GroupBy Table Rowto Variable Rule Engine Math Formula Rule Engine Lag Column Column Filter RecursiveLoop Start Recursive 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: RE90273
Created at: 2022-04-27
On NodePit since: 2022-04-27
Last update: 2024-04-28
Created with KNIME version: v4.5.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!