Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
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.
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.
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.
