Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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
ACE Emeritus
ACE Emeritus

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

randreag
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
17 - Castor
17 - Castor

Challenge Completed

 

Spoiler
Weekly_Challenge_235.JPG
Ladarthure
14 - Magnetar
14 - Magnetar

my solution!