Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

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

Challenge #120: Popular Baby Names

LucieReveillere
Météoroïde
Révélation
LucieReveillere_0-1574847235442.png
sachinw
Astéroïde

My Solution:

KevinHarrison
Astéroïde
Révélation
KevinHarrison_0-1575431887906.png

This was a fun one. 

danicahui
Astéroïde
Révélation
Challenge 120 2019-12-04.jpg
sonyakasenkramer
Astéroïde

I did it! Looking at everyone else's solutions, it seems like i need to get over myself and learn regular expressions. Here we go.

Révélation
sonyakasenkramer_0-1575477432930.png
echuong1
Alteryx Alumni (Retired)

7 tools, but seems like I can definitely simplify this...

 

Révélation
echuong1_0-1575660065076.png
ozdogand
Astéroïde

fun exercise..

Révélation
ozdogand_0-1577192377028.png
Hjardine
Astéroïde
Révélation
text to columns tool on Field 1, formula to get year out of file link. Then I used some joins and summarize tools to calculate the highest for each year. Also cache'd the original names data set so the workflow wouldn't take forever each time. 

Hjardine_0-1577476230794.png
nivi_s
Astéroïde

Solved!

 

Révélation
nivi_s_0-1577497632883.png
brudnicki
Météore

Below is my solution