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

grantski
5 - Atom

I'm brand new to Alteryx (3 days!) and this is what I came up with. Fun challenge!

 

 

 

Spoiler
Capture.PNG
Asal
7 - Meteor

Hi,

this is my approach. 

piotrzawistowski
8 - Asteroid
 
JORGE4900
8 - Asteroid

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.

 

Spoiler
2019-06-26_17-02-34.jpg

 

viveknshah
8 - Asteroid
Spoiler
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! challenge120_vivek.JPG
DataG8
8 - Asteroid

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.

Spoiler
Spoiler.PNG
justindavis
10 - Fireball

11 mins for me on this one.

Spoiler
challenge_120_solution_justindavis.PNG
klyuka
8 - Asteroid

Beautiful database

ELPC
8 - Asteroid

Here's my solution.  

 

 

kelsey_kincaid
12 - Quasar
Spoiler
Challenge120-KA.PNG