community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #120: Popular Baby Names

Atom

 

 

First time posting.

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

 

Alteryx Challenge.PNGAlteryx Challenge2.PNG

Meteor

Solution attached. Similar to others' solutions.

 

Spoiler
challenge_120_jackie.JPG
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!  

Alteryx Certified Partner

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

 

 

 

Asteroid

Just about the same as most others :)

Spoiler
2018-06-13_12-36-54.jpg
Alteryx Certified Partner
Alteryx Certified Partner

@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 reboot. Order shall return.
Alteryx Certified Partner

Solution attached.

Bolide
Bolide

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

Alteryx Certified Partner
Alteryx Certified Partner

@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 reboot. Order shall return.

@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