Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #120: Popular Baby Names

Etienne
8 - Asteroid

Solution attached

rslopez2
8 - Asteroid

Pretty fun Challenge!

 

-Used REGEX To extract Name, Gender, Frequency & Year

-Split by Gender

-Used Summarized to group by Year and Find Max Frequency and Return First name to get names without needing extra tools

-Joined to Get Female/Male names for Year in same rows

 

Spoiler
RL_Challenge_120.png
PaulN
Alteryx Alumni (Retired)
 
garthn555
8 - Asteroid
Spoiler
120.png
AdriandeArriba
7 - Meteor

My solution attached.

 

Spoiler
clipboard_image_0.png
Sihlex1
7 - Meteor

#120

Ellie_P
8 - Asteroid
 
dpak
5 - Atom

I have used formula here to extract the year from the file name.

Deevi
8 - Asteroid
Spoiler
120 pic.png
AndrewS
11 - Bolide

Nothing new to see here.