Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

kelseycouzzo
6 - Meteoroid

First time finishing a challenge!

lnihaal
6 - Meteoroid

This took me quite a while but I solved this in the end !! Phewww...!

Spoiler
lnihaalWC120Solution.PNG
yuryanusa
6 - Meteoroid

It is a wonderful project and teach me a lot.

Samanthaj_hughes
ACE Emeritus
ACE Emeritus

Awh, baby names. 

#Alteryxrocks
Paul123
7 - Meteor

 

Hello I am a beginner and was trying this. I am confused on how to convert filename into Year.I found many using RegEx but I didnt understand it seeing its documentation also. 

 

Similarly for selecting highest frequency I used sampling tool (group by year and select first row of each year).But what if to names in a same year has same frequency how do i include both names?

 

Further I have attached my soln below.

I hope to get poitive suggestions.

RNG
8 - Asteroid

.

Ddip11
5 - Atom

Done!

aviseq
6 - Meteoroid

The Simplest, Least Time Taking, with minimal number of tools (6) used , Solution of Weekly Challenge #1

TOOL FLOW

INPUT-> Text-to-Columns -> Select -> Sort -> Sample -.> Filter -> Join -> OUTPUT

Will_Condon
7 - Meteor

Week 3, Day 2 of ADAPT program.  Challenge #120. 

Harshitha_K
6 - Meteoroid

Here's my solution. Thank you!