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

kas
8 - Asteroid

 

 

First time posting.

My workflow is quite minimal, but the results seem correct..

 

Alteryx Challenge.PNGAlteryx Challenge2.PNG

jackie_liu
8 - Asteroid

Solution attached. Similar to others' solutions.

 

Spoiler
challenge_120_jackie.JPG
SuzanneMc
6 - Meteoroid

@ChristineB looks like I need to up my RegEx Parce game but will still give the other produce idea a go, thanks for the reminder!  

Charity_K_Wilson
10 - Fireball

I added a bit of reporting to my solution.  I wanted to see the names over time, how popular they were, and for how long they kept that #1 spot.  I'm still learning how to use the Charting tool, so not the world's best chart.

 

Spoiler
Challenge 120, Baby Names.jpgBaby Names over time.png

 

 

 

JordyMicheal
11 - Bolide

Just about the same as most others :)

Spoiler
2018-06-13_12-36-54.jpg
MarqueeCrew
20 - Arcturus
20 - Arcturus

@ChristineB,

 

I don't want to spoil the party.  Far be it from me to be a baby about it.  But I'd like to point out that @patrick_digan & @NicoleJohnson (both ACEs and the latter the 2018 Grand Prix winner) have turned in UNEQUAL results.  Their answers do NOT match the expected output.

 

My dear friend and colleague, @JoeM and I instructed a training class at #alteryx18 on CReW macros.  If either of the aforementioned Alteryx Experts had taken the training, they would have employed a CReW test macro, Expect Equal (BETA) and found that their results were both sub par.  

 

Spoiler
capture.png

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
KOBoyle
11 - Bolide

Solution attached.

ggruccio
ACE Emeritus
ACE Emeritus

Wow!  if @MarqueeCrew is checking results, good thing I took his class!  LOL :)

MarqueeCrew
20 - Arcturus
20 - Arcturus

@ggruccio,

 

They should give you extra credit for that reply.  I just got off of the phone with @patrick_digan and he has found the error(s) in his ways.

 

Long live CReW!

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
patrick_digan
17 - Castor
17 - Castor

@MarqueeCrew

 

 LawfulPoisedHorseshoecrab-max-1mb

 

At least I'm in good company with @NicoleJohnson. To clear my good name, I've detailed my missteps...

 

Spoiler
1. I added an extra space to the COLUMN HEADING Female Names. 
2. I misspelled Female in the COLUMN HEADING Frequency of Female Names. 
3. I didn't add a space at the beginning of the COLUMN HEADING Frequency of Male Names.

...and corrected them

 

Spoiler
Capture.PNG