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

[Kilbyflow_Designer]

Complete!!

Spoiler

 

[Pilsner]

My solution:

Spoiler

 

[jli924]

My solution

[aiahwieder]

Apparently all I do now is use the Rank tool!

[dYoast]

My results.

Spoiler