Challenge #410: Optimizing Winter Sports Inventory

[Jonathon-Sheppard]

A headscratcher at times. The first time I'd ever come across 'Julian' date formats and I didn't know it was easily converted by a simple 'ToDate' expression. Spent ages trying to figure out why I wasn't getting the same dates as the output solution data.

Also couldn't figure out a quicker way of transposing or summarising the messy data - ended up having six streams that treated the data and sorted it all into rows correctly.

This exercise taught me that i have a LONG way to go until I'm even a basic level Alteryx user!

[AronasZilys]

Spoiler

[rmassambane]

410