Weekly Challenges

Jonathon-Sheppard · ‎05-07-2025

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!