Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

Batch Macro + ARIMA complications

5 - Atom

Hi everyone,


I'm currently trying to build a workflow using a batch macro inside another batch macro, in order to be able to forecast the next year of data of several SKUs and promotions through an ARIMA. The original data base provides a Concatenate of certain info regarding promotions in different stores throughout the year, along with the SKUs promoted at the time. Each promotion includes data from the last week of 2015 to the last week of 2018, although we only want to use the info from 2016-2017, and forecast 2018 (to compare to the real numbers).


What we would like as an outcome is a forecast for the volume of each SKU in each promotion, while keeping clear when it's two different stores/promotions/skus.


Currently the initial workflow assigns a RecordID to each promotion (concatenate) then runs the SKUs batch macros for every RecordID. The SKUs macro gets the list of SKUs of the promotion and uses it on the Arimas batch macro, which runs an ARIMA for each SKU of that promotion. Once all SKUs have their forecast, the next RecordID enters SKUs batch macro and so on.


At the time I've designed both Batch Macros and the outer workflow, but I'm getting error after error when I run it. The most constant error happens when it executes the batch macro that runs the ARIMA, stating the error as "Error in plot.window(...): need finite 'ylim' values".


Does anyone have any idea on how to fix this?


Appreciate any help. I include the workflow + batch macros + data base sample


Hi @AlexisRdz 


From what I can see online, it looks like your error message shows up as a result of "NA" values: 


The ARIMA tool is built on underlying R code so this is an R specific error message. 


I hope this helps!