Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
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

Highlighted
6 - Meteoroid

First attempt to any challenge on this community. Feel good to get it right.

 

 

Highlighted
5 - Atom

My solution...mary is the winner

Highlighted
8 - Asteroid

Hi,

 

Interested challenge!! Please find the solution. 

I looked up the solution provided and realized that I arrived at the solution in somewhat different manner. This might seem oversimplified but gets the work done. However, after going through the solution provided, I learnt a lot about certain tools which I had never used in my workflows (Transpose, Multirow Formula etc.). This helped me in reviewing these tools and hopefully using them in upcoming challenges to simplify the analysis. Thanks for an engaging challenge!!

 

*Spoiler*

-Once you are able to sort the data by Year and Top Frequencies by Male & Female, the next challenge is to convert the data such that a single row shows Name & Frequency of both Male & Female category, instead of 1 row for Male & 1 row for Female.

-In order to tackle this, we can use Select tool multiple times. 

- First I sample my data for all female records by using '1 of every N rows' option under 'Select sample type'. Here N=2 and therefore the resulting table skips alternate entries of Male and final result shows only female entries for all years.

-Next, I use the Select tool and use' Skip first N rows' , where N=1. Then the previous step is repeated and resulting table will have Male entries for all years.

- Next you need to Join both data using JOIN Tool (year being the specific field) and the resulting table gives the final result.

 

Hope you found the solution useful! Thanks!

 

 

 

 

Highlighted
8 - Asteroid

Thanks

Highlighted
Alteryx Certified Partner

My solution.

Spoiler
AkimasaKajitani_0-1601545703643.png

 

 

Highlighted
6 - Meteoroid

alfugarzi_0-1601616243862.png

 

Highlighted
7 - Meteor

HEREEEEEEEEEEEEEEEEEEEEEEEEE

Highlighted
8 - Asteroid

Done long time ago!

Highlighted
6 - Meteoroid

Below is my workflow to this challenge. 

Highlighted
6 - Meteoroid

Hello,

 

Below is my solution for the baby challenge. Had some issues trying to post this from the ADAPT fundamentals.