Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
6 - Meteoroid
Spoiler
LucieReveillere_0-1574847235442.png
sachinw
8 - Asteroid

My Solution:

KevinHarrison
8 - Asteroid
Spoiler
KevinHarrison_0-1575431887906.png

This was a fun one. 

danicahui
8 - Asteroid
Spoiler
Challenge 120 2019-12-04.jpg
sonyakasenkramer
8 - Asteroid

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.

Spoiler
sonyakasenkramer_0-1575477432930.png
echuong1
Alteryx Alumni (Retired)

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

 

Spoiler
echuong1_0-1575660065076.png
ozdogand
8 - Asteroid

fun exercise..

Spoiler
ozdogand_0-1577192377028.png
Hjardine
8 - Asteroid
Spoiler
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
8 - Asteroid

Solved!

 

Spoiler
nivi_s_0-1577497632883.png
brudnicki
7 - Meteor

Below is my solution