Challenge #235: Spell It Out For Me - Part 2

[Jonathan-Sherman]

Challenge 235 is done! I was determined not to hard code the column headers so took me a while to think up a dynamic approach...

Spoiler

[kaianderson]

Really loved this challenge! Excellent for critical problem solving.

[NicoleJohnson]

This was a super cool challenge! Now if only someone would write out some of those nice number words on a check for ME... 

 

Spoiler

The key to this one was understanding out to generate all the number words between 1 and 99, and then grouping the values from the Challenge 234 output into the right 3-digit combinations. Really had fun figuring out the most streamlined way I could find to get to this solution!

Cheers!

NJ

[randreag]

here my solution!!

[ConradW]

[ehughes]

Took a couple of attempts to get to something I was happy with but here's my solution

Spoiler

 

[SeanAdams]

I think I probably took a super long way round on this.

Did it 2 ways - with Alteryx (with a macro) and with Python

Spoiler

The Python solution works super well - 2 or 3 lines of code:


The Alteryx solution creates a simple lookup set for all numbers from 0 to 999 (macro) and then does a simple enrichment of the split data.

#SnakingMyWayThruChallenges

[danicahui]

Spoiler

[JosephSerpis]

Challenge Completed

Spoiler

[Ladarthure]

my solution!