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

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
9 - Comet

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
11 - Bolide
Spoiler
Challenge120-KA.PNG