Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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
The names, gender, and frequency were very easy to split; parsing the year also easy: .+(\d{4}).+
I guess that the trick here is to sort by year gender and frequency--(on descending order).
After that is just getting the unique names and frequency by gender and year;
split and join to finish.
Saqueador
I really wanted to try out crosstab for this and noticed not many other solutions have used that and hence didnt need the additional joins I had to add in the end to normalise the output but yay ! crosstabs to the rescue! 
So many different ways to get to the same answer. All the cool kids are named Michael. My name had a good run there for awhile, waiting for the comeback. The cache and run workflow was a really nice tool for this challenge.
