Challenge #120: Popular Baby Names

[Nmetzgen1]

Solution attached

[dhtay]

My workflow's a little longer than necessary, but it's only because I was trying to solve it as fast as possible. 😃 I did get stuck at the splitting genders part. Looks like there are some things that the cross tab tool can't do.

Nice challenge!

[Marcel_Gavrila]

here's my solution!

Spoiler

[RWvanLeeuwen]

fun challenge and quite a heavy dataset... maybe I'll have a look at what obscure names are in use today 😄

Spoiler

[fmeo]

Spoiler

[mbogusz]

Spoiler

Regex, Multi-Row Formula <--- AWESOME TOOLS

Surprises me there are only 10 Top Female Names and 8 Top Male Names across 1880-2017.  Shows how common names are.

[mcultrera]

Fun and not too difficult. Confidence booster! 🙂

[Sunil_Jangid_96]

[lashanbannister]

After I save the file and exit Alteryx the input file says 'not found'.  How can I save it so that I can come out and get back into the workflow without having to start over?

[wwatson]

Solution enclosed