the table has the year and 332 cities And I want to predict more than ten years up to 2022 the problem is that the output of the Arima model is only one city and I want the whole cities to be predicted and included in the output table, I tried to use column loops but it didn’t work since we need the date column to be always present.
use a column loops nodes approach.
analyze each city by iterating over the data and attaching the date to each city.
edit: actually they are other approach from the experts which more efficient/fast, in my unoptimized workflow here is just to give an idea to start with.
the output (scorers) here is the results from my selective configurations.