core.noscript.text
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Happy National Hammock Day! Wish I was in one on the beach between two palm trees...
my solution
It's best to sort dates with Date-Time recognition within Alteryx tools rather than splitting into columns and sorting as text strings.
definitely learning! decompose-->reconstitute-->discard-->produce the desired outcome
Answered
Hi
Please find attached my solution:
similar to solution but I managed to use a few less tools as just let Alteryx default to 1400 as a start year.
Solution attached
Solution attached.