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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #120: Popular Baby Names

Meteor
 
Alteryx Partner

Not too bad - I'm a lot better at this when I don't have to parse dates....

 

These challenges are definitely improving my skills

 

Spoiler
Process:
- Parse name/**bleep**/number data
- Parse year
- Cleanup and sort (Year: Asc, **bleep**: Asc, Instances: Desc)
- Grab first instance (grouped by year and **bleep**
- Separate female from male
- Rename fields
- Join data for final output

MySolution.PNG
Alteryx Partner

Here is my solution !

Alteryx Partner
Spoiler
clipboard_image_0.png
Meteor

solved

Meteor

Getting better with data cleansing thanks to these challenges!!

Spoiler
Weekly Challenge 120 Solution.PNG

 

Asteroid
 
Meteoroid

I did it a little differently than the posted solution, but got there anyway!

Asteroid

Hi All,

 

Please find my Result below.

 

Spoiler
Text to Columns, Select to Change data type, Regex for year Split Male and Female summarize to the Max, Join to get the name, Then join male and female back together.

 

Thanks

Mat

Asteroid