Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Time Series Macro Issue

Billigans
8 - Asteroid

Hello All, 

 

I get the following errors when I run a time series batch macro for ARIMA modeling with a covariate. The macro is running each SKU in batches. The error does not appear when I run the same record set in the actual macro, only when I run it in the wrapper. Any help is greatly appreciated. 

 

ARIMA Covar. Factory Macro (3) Record #1: Tool #14: ARIMA: Error in matrix(covar.vec, nrow = length(covar.vec), ncol = 1, dimnames = list(1:length(covar.vec), :
ARIMA Covar. Factory Macro (3) Record #1: Tool #14: ARIMA: Execution halted
ARIMA Covar. Factory Macro (3) Record #1: Tool #14: Tool #35: Tool #6: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #14: Tool #46: Tool #6: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #14: Tool #51: Tool #6: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #14: ARIMA: The R.exe exit code (1) indicated an error.
ARIMA Covar. Factory Macro (3) Record #1: Tool #18: ARIMA: Error in ts(the.y, frequency = freq, start = strt) :
ARIMA Covar. Factory Macro (3) Record #1: Tool #18: ARIMA: Execution halted
ARIMA Covar. Factory Macro (3) Record #1: Tool #18: Tool #35: Tool #6: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #18: Tool #46: Tool #6: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #18: Tool #51: Tool #6: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #16: An empty or invalid spatial object was found. Consider filtering them out if you are using Spatial Statistics.
ARIMA Covar. Factory Macro (3) Record #1: Tool #17: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #16: Tool #25: Tool #6: No valid fields were selected.
ARIMA Covar. Factory Macro (3) Record #1: Tool #16: TS Forecast: The model NA is not an allowed time series model.
ARIMA Covar. Factory Macro (3) Record #1: Tool #18: ARIMA: The R.exe exit code (1) indicated an error.

 

 

1 REPLY 1
RishiK
Alteryx
Alteryx

Hi there

 

One of your issues were the NULLs present in Sum_Rev and Item#.

 

I have created a sample workflow as attached with the TS Model Factory tool.  I think it is a better one for you to understand what is happening.

 

Ultimately you do not have enough data for each item# group to produce a time series or to create a forecast.

Labels