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
8 - Asteroid
 
Highlighted
6 - Meteoroid
Spoiler
challenge_120.jpg
Highlighted
Alteryx Certified Partner

 

 

 

Spoiler
 Capture.PNG

 

Highlighted
7 - Meteor

Took longer than I had hoped (make to change your strings to a different data type) but here is my solution! Pretty much the same as a few others here. 

Highlighted
12 - Quasar
12 - Quasar

Love challenges like these with large data sets.  

Highlighted
14 - Magnetar
14 - Magnetar

Nothing like a weekly challenge to allay the post Inspire blues! I wanted to go a least tools route, so was determined to do all of the parsing in a single formula tool (which also let me rename and assign data types immediately)

Natural instinct is Regex_replace. But like @patrick_digan, noticed this was SLOW. So, used combinations of Left, Right, Substring, Length. Ugly formulas but they work and they're fast!

Only different approach I took was a Make Columns tool instead of the Filter/Join combo. Thanks @NicoleJohnson for introducing me to this tool in a challenge long ago.

Spoiler
image.png
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My version of the challenge, different from the others, used a summarize join instead of a sample first 🙂 

Highlighted
Alteryx Certified Partner

I went down the same route as @patrick_digan

 

Spoiler
120.png
Highlighted
12 - Quasar
Spoiler
Challenge #120.PNG
Highlighted
Alteryx Certified Partner

Here is my workflow.

Spoiler
Capture.PNG