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.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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

Jonathan-Sherman
15 - Aurora
15 - Aurora

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
Jonathan-Sherman_0-1602630819075.png

 

kaianderson
8 - Asteroid

Really loved this challenge! Excellent for critical problem solving.

 

kaianderson_0-1602782602039.png

 

NicoleJohnson
14 - Magnetar
14 - Magnetar

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!

WeeklyChallenge235.JPG

Cheers!

NJ

aruiz-itp
11 - Bolide

here my solution!!

 

aruiz-itp_0-1603807612104.png

 

 

ConradW
8 - Asteroid

ConradW_0-1603967064346.png

 

ehughes
9 - Comet

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

Spoiler
Img 235.png

SeanAdams
17 - Castor
17 - Castor

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

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

 

Result.png

 

Spoiler

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

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.

AyxSolution1.pngAyxSolution2.png

#SnakingMyWayThruChallenges



danicahui
8 - Asteroid
Spoiler
Challenge 235 2020-11-09.jpg
JosephSerpis
15 - Aurora
15 - Aurora

Challenge Completed

 

Spoiler
Weekly_Challenge_235.JPG
Ladarthur
13 - Pulsar
13 - Pulsar

my solution!