Challenge #120: Popular Baby Names

[kas]

First time posting.

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

[jackie_liu]

Solution attached. Similar to others' solutions.

Spoiler

[SuzanneMc]

@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]

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

[JordyMicheal]

Just about the same as most others :)

Spoiler

[MarqueeCrew]

@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

Cheers,

Mark

[KOBoyle]

Solution attached.

[ggruccio]

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

[MarqueeCrew]

@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

[patrick_digan]

@MarqueeCrew

 

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