Icon

(Optional)_​Linear_​Regression

Pre-completed steps to set up the data. The CSV reader pullsfrom this location:knime://knime.workflow/../_INPUT/WeeklySalesAtSize(FakeData).csv InsertPre completed Data Setup and Loop start - Part 0 Also pre-completed. Loop set-up to run through each month one at a time, excluding the first 5 months (as we willbe calculating a 6 month rolling average We need to filter for the P6M and then kick off a group loop.-> Date/Time shift the month we are focused on back 6 months.-> Rule-based Row Filter to include P6M-> Group Loop Start to run through each company and each size Setup Inner Loop - Part A Run Linear Regression and extract variablesPart B -> Linear Regression Learner (predicting volume sales based on price/su)-> Table Column to Variable to extract the coefficients of the model-> Math Formula nodes to input the intercept and gradient of the line of best fit Close both loops and filter unneeded columns; join andoutput -> 2x loop end-> Column Filter-> Joiner to join back to original data-> CSV writer to knime://knime.workflow/../_OUTPUT/WeeklySalesWithRegression.csv Run Linear Regression and extract variablesPart B We need to filter for the P6M and then kick off a group loop.-> Date/Time shift the month we are focused on back 6 months.-> Rule-based Row Filter to include P6M-> Group Loop Start to run through each company and each size -> 2x loop end-> Column Filter-> Joiner to join back to original data-> CSV writer to knime://knime.workflow/../_OUTPUT/WeeklySalesWithRegression.csv -> Linear Regression Learner (predicting volume sales based on price/su)-> Table Column to Variable to extract the coefficients of the model-> Math Formula nodes to input the intercept and gradient of the line of best fit Close both loops and filter unneeded columns; join andoutput Setup Inner Loop - Part A Also pre-completed. Loop set-up to run through each month one at a time, excluding the first 5 months (as we willbe calculating a 6 month rolling average Pre-completed steps to set up the data. The CSV reader pullsfrom this location:knime://knime.workflow/../_INPUT/WeeklySalesAtSize(FakeData).csv InsertPre completed Data Setup and Loop start - Part 0 Node 138Node 139Node 142Node 143Node 144Node 145Node 146Node 147Node 150Node 152Node 153Node 154Remove first5 monthsNode 156Node 157Node 161Node 162Node 164Node 165Node 167Node 154Remove first5 monthsNode 170Node 171Node 172Node 176 Date/Time Shift(legacy) GroupBy Table Row To VariableLoop Start (deprecated) Rule-basedRow Filter Math Formula Math Formula Linear RegressionLearner Table Column toVariable (deprecated) Group Loop Start Loop End(deprecated) Loop End(deprecated) Sorter Row Filter String to Date/Time(legacy) String Manipulation Joiner (deprecated) CSV Writer(deprecated) Column Filter CSV Reader(deprecated) Data Setup GroupBy Sorter Row Filter Table Row To VariableLoop Start (deprecated) String Manipulation String to Date/Time(legacy) Data Setup CSV Reader Pre-completed steps to set up the data. The CSV reader pullsfrom this location:knime://knime.workflow/../_INPUT/WeeklySalesAtSize(FakeData).csv InsertPre completed Data Setup and Loop start - Part 0 Also pre-completed. Loop set-up to run through each month one at a time, excluding the first 5 months (as we willbe calculating a 6 month rolling average We need to filter for the P6M and then kick off a group loop.-> Date/Time shift the month we are focused on back 6 months.-> Rule-based Row Filter to include P6M-> Group Loop Start to run through each company and each size Setup Inner Loop - Part A Run Linear Regression and extract variablesPart B -> Linear Regression Learner (predicting volume sales based on price/su)-> Table Column to Variable to extract the coefficients of the model-> Math Formula nodes to input the intercept and gradient of the line of best fit Close both loops and filter unneeded columns; join andoutput -> 2x loop end-> Column Filter-> Joiner to join back to original data-> CSV writer to knime://knime.workflow/../_OUTPUT/WeeklySalesWithRegression.csv Run Linear Regression and extract variablesPart B We need to filter for the P6M and then kick off a group loop.-> Date/Time shift the month we are focused on back 6 months.-> Rule-based Row Filter to include P6M-> Group Loop Start to run through each company and each size -> 2x loop end-> Column Filter-> Joiner to join back to original data-> CSV writer to knime://knime.workflow/../_OUTPUT/WeeklySalesWithRegression.csv -> Linear Regression Learner (predicting volume sales based on price/su)-> Table Column to Variable to extract the coefficients of the model-> Math Formula nodes to input the intercept and gradient of the line of best fit Close both loops and filter unneeded columns; join andoutput Setup Inner Loop - Part A Also pre-completed. Loop set-up to run through each month one at a time, excluding the first 5 months (as we willbe calculating a 6 month rolling average Pre-completed steps to set up the data. The CSV reader pullsfrom this location:knime://knime.workflow/../_INPUT/WeeklySalesAtSize(FakeData).csv InsertPre completed Data Setup and Loop start - Part 0 Node 138Node 139Node 142Node 143Node 144Node 145Node 146Node 147Node 150Node 152Node 153Node 154Remove first5 monthsNode 156Node 157Node 161Node 162Node 164Node 165Node 167Node 154Remove first5 monthsNode 170Node 171Node 172Node 176 Date/Time Shift(legacy) GroupBy Table Row To VariableLoop Start (deprecated) Rule-basedRow Filter Math Formula Math Formula Linear RegressionLearner Table Column toVariable (deprecated) Group Loop Start Loop End(deprecated) Loop End(deprecated) Sorter Row Filter String to Date/Time(legacy) String Manipulation Joiner (deprecated) CSV Writer(deprecated) Column Filter CSV Reader(deprecated) Data Setup GroupBy Sorter Row Filter Table Row To VariableLoop Start (deprecated) String Manipulation String to Date/Time(legacy) Data Setup CSV Reader

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: richardson.bg
Created at: 2017-05-15
On NodePit since: 2024-10-14
Last update: 2025-06-12
Created with KNIME version: v5.2.0

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

Try NodePit Runner!