Challenge #94: Have we reached Peak Pumpkin?

[Tgigs]

My solution attached.

Was not able to complete 100% due to time constraint, but did get the data batch imported, replaced nulls with the averages, and developed one time series model for bakery.

[lynnesonney]

pumpkin spice anyone?

[Angelica_Obi]

Spoiler

This challenge stressed me out lol

[JoachimCaronTIL]

Here is my solution

Spoiler

 

[mshishido]

fun

[Chris-Nienart]

The factory tools simplify this exercise significantly by performing a specialized batch macro.

Regarding the inputs, in this very special case, all the spreadsheets have the same sheet names and formats so you can pull in all of them at once without a macro. 

For practicality, I'd suggest splitting the data prep from the time series analysis. Once you have the data ready, there's no need to recreate it on each workflow run.

Spoiler

Note: the original xlsx files aren't included in the zip file as the Export function in Alteryx doesn't find the dynamically chosen files.

[CBUSYINZER]

I'm not sure if I did this one correctly, the answers are different and the tools but I think I mostly have it.

[H_a_n_g_C_h_e_n__x3]

I tried. Went the Batch Macro route

[Bobbyt23]

Really enjoyed that challenge, apart from the predictive tools as so unfamiliar with them.

[matt_sexton17]

Spoiler

Fun quick challenge to get through the prep - couldn't get the model factories on my version, and followed Barnes' lead on macros but still don't know what was wrong with it. Just could not get [Name] = "%Question.ControlParam.Prod%" to pass - eventually tried connecting the control parameter