community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #120: Popular Baby Names

Meteoroid

And voilà! 

 

Spoiler
Challenge_120.JPG

The part I like the most is to see how people resolved this but in so different ways :-)

Best regards,

Jessica

Alteryx Partner

My solution:

Spoiler
challenge 120.jpg
Meteoroid

This was my first challenge! Thanks for posting these!

Alteryx Partner

Hi ,

 

My solution as follows, i added a chart to see how the names compare.(Frequency vs  Count no. of Years)

Spoiler
AlteryxGui_2018-07-05_14-50-39.png

 AlteryxGui_2018-07-05_14-55-00.pngAlteryxGui_2018-07-05_14-55-17.png

Alteryx Certified Partner

Does anyone else feel all warm and fuzzy when they get to use Regex?

Anyone?

 

*gets coat*

 

Spoiler
I used the text to columns to split out the first field, then used Regex to parse out the 4 digit year from the filename using \d\d\d\d.
I then grouped the records by year and gender to find the maximum frequency and joined back on these fields to the main stream.
Then I simply split by gender and joined on the year.

Workflow.PNGResults.PNG 

 

Alteryx Partner

My first challenge :) 

 

Spoiler
challenge.PNG

Solution attached, thanks!

Meteor

Here is my solution.

Alteryx Partner

Nothing fancy, my solution.

Asteroid

My solution :)