Icon

KNIME_​Forecast_​fail

Tab1 (2009-2010)Tab2 (2010-2011)Merge both tablesDelete duplicatesNode 6Node 7Delete all cancelled ordersNode 22Node 23Choose ProductChoose last 10 rowsChange Date&TimeChange Date&TimeChange String back to Date&Time Format"Date"Filter for relevant ColumnsReplace "?" Quantity with 0Node 53Node 54Node 55Node 56Index of 10th rowfrom the backShow only last 10 rowsLast datedate + 1merge with date +1Node 62Sum Quantity per daySelect new rowFilter for relevant rowsFilter for relevant rowsData + new rowonly rows in the futureTimestamp Alignment Excel Reader (XLS) Excel Reader (XLS) Concatenate DuplicateRow Filter Missing Value Missing Value(Apply) Row Filter RecursiveLoop Start Recursive Loop End Row Filter Row Filter String Manipulation Date&Time to String String to Date&Time Column Rename Column Filter Missing Value Lag Column PolynomialRegression Learner RegressionPredictor Extract TableDimension Math Formula(Variable) Row Filter GroupBy Date&Time Shift Concatenate Lag Column GroupBy Row Filter Column Filter Column Filter Concatenate Row Filter Tab1 (2009-2010)Tab2 (2010-2011)Merge both tablesDelete duplicatesNode 6Node 7Delete all cancelled ordersNode 22Node 23Choose ProductChoose last 10 rowsChange Date&TimeChange Date&TimeChange String back to Date&Time Format"Date"Filter for relevant ColumnsReplace "?" Quantity with 0Node 53Node 54Node 55Node 56Index of 10th rowfrom the backShow only last 10 rowsLast datedate + 1merge with date +1Node 62Sum Quantity per daySelect new rowFilter for relevant rowsFilter for relevant rowsData + new rowonly rows in the futureTimestamp Alignment Excel Reader (XLS) Excel Reader (XLS) Concatenate DuplicateRow Filter Missing Value Missing Value(Apply) Row Filter RecursiveLoop Start Recursive Loop End Row Filter Row Filter String Manipulation Date&Time to String String to Date&Time Column Rename Column Filter Missing Value Lag Column PolynomialRegression Learner RegressionPredictor Extract TableDimension Math Formula(Variable) Row Filter GroupBy Date&Time Shift Concatenate Lag Column GroupBy Row Filter Column Filter Column Filter Concatenate Row 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: leoniegalm
Created at: 2021-02-25
On NodePit since: 2021-03-07
Last update: 2024-04-27
Created with KNIME version: v4.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!