This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I just a quick question about the Predictive tools within Alteryx. I was wondering if it is possible, if you already have existing time series data, to allow Alteryx to predict beyond the data that is already in place. I've seen situations where users have given Alteryx specific data to allow it to predict from scratch what the outcome will be using either the ARIMA or ETS method, but nothing about doing what I suggested. It seems like it should be possible going from the ETS or ARIMA tool into the TS Plot tool, but so far I haven't successfully been able to make that happen.
The easy way would be to run from one source into multiple ARIMA tools, and set each to forecast a different target field. If you wanted one tool to generate forecasts for multiple fields, you would have to write an iterative macro, which I'm guessing is certainly possible, but might get a bit involved.
Actually, there are macros on the Predictive District of the Gallery that solve the problem of performing multiple predictions. The TS Model Factory macro creates models for multiple items at once, and the TS Forecast Factory macro estimates forecasts for these models. If you want more customization than these macros allow, @JohnJPS's approach will work. However, the R tool takes about 2 seconds to initialize every time, so putting an R tool in an iterative macro can create some performance concerns.