Statistical Predictions

Hello, everyone!

I’ve just started usin Knime, and I would apreciate if you could help me.
I have a data base with historical sales and I need to generate sales forecasts for the next 3 months using SARIMA model. But I need to do this for all the combinations of ChanelXFamily I have. My data base is a table like the image below:
image

For the output I am expecting something like this:
image

I was able to generate a forecast filtering manually one combination of chanelXfamily, but since I have more than 100 combinations it won’t be viable to do one by one.
How can I do this automatically?

Hope you can help me.
Thanks!

Hi @LahysPortugal,

if I understand your question correctly, you might be looking for the Group Loop Start (and Loop End) node.
In there, you can configure the node to include CHANEL and FAMILY (and tick Enforce inclusion, to avoid any other columns being added to the group).

That will do everything you have in between start and end for each combination of CHANEL and FAMILY, one after another.

Hope this helps!

Kind regards
Marvin

ps. if your KNIME has internet access, you can simply drag&drop the links in my post into your workflow :slight_smile:

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.