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.
alteryx Community

# 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

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

8 - Asteroid

Really loved this challenge! Excellent for critical problem solving.

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!

Cheers!

NJ

11 - Bolide

here my solution!!

8 - Asteroid

9 - Comet

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

Spoiler

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

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

8 - Asteroid
Spoiler
15 - Aurora

Challenge Completed

Spoiler
13 - Pulsar

my solution!