community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #120: Popular Baby Names

Meteoroid
Spoiler
LucieReveillere_0-1574847235442.png
Asteroid

My Solution:

Spoiler
KevinHarrison_0-1575431887906.png

This was a fun one. 

Asteroid
Spoiler
Challenge 120 2019-12-04.jpg

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
Alteryx
Alteryx

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

 

Spoiler
echuong1_0-1575660065076.png
Alteryx Partner

fun exercise..

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

Solved!

 

Spoiler
nivi_s_0-1577497632883.png
Meteor

Below is my solution