We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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