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
7 - Meteor

 

 

First time posting.

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

 

Alteryx Challenge.PNGAlteryx Challenge2.PNG

8 - Asteroid

Solution attached. Similar to others' solutions.

 

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

Highlighted
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

 

 

 

Highlighted
Alteryx Certified Partner

Just about the same as most others :)

Spoiler
2018-06-13_12-36-54.jpg
Highlighted
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.
Highlighted
Alteryx Certified Partner

Solution attached.

Highlighted
12 - Quasar
12 - Quasar

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

Highlighted
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.
Highlighted
15 - Aurora
15 - Aurora

@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