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 #234: Spell It Out For Me - Part 1

NicoleJohnson
14 - Magnetar
14 - Magnetar

My solution! 

 

Spoiler
Key for me on this one was to save myself some unnecessary re-ordering by reversing the string at the beginning. Then splitting out the digits, ordering by ID, then deriving the ending column number and pivoting the columns.
WeeklyChallenge234.JPG


Cheers!

NJ

Malvim
11 - Bolide

Waiting for part 2 😃

 

Spoiler
Malvim_0-1601092131674.png

 

jdunkerley79
16 - Nebula
16 - Nebula
Spoiler
jdunkerley79_0-1601110257693.png

 

kelly_gilbert
12 - Quasar

SO much fun!

 

Spoiler
I used a few more tools, because I wanted it to be totally dynamic (able to handle numbers of any reasonable width, number of decimal places, etc.)

Of course, the tricky part is that the crosstab tool sorts columns alphabetically. I was expecting it to sort 1, 10, 11, 12, 2, 3, etc., so I went through the extra step of padding the column headers and then removing the padding later. However, I learned from @patrick_digan's solution that crosstab sorts the columns numerically if the field selected for the column header is a numeric type!


kelly_gilbert_0-1601153133885.png

 

Virender
7 - Meteor

I am able to build dynamic solution

Spoiler
Capture.PNG

 

Assaf_m
11 - Bolide

My solution attached 🙂

 

nice challenge.

 

 

navneetmohit
6 - Meteoroid

Here is my take on this. Hope this is the shortest way to get that working!

RichoBsJ
10 - Fireball

Hi! Nice Challenge!

 

Spoiler
Captura de pantalla 2020-09-27 132651.png
dsmdavid
11 - Bolide
Spoiler
dsmdavid_0-1601221223156.png

 

JoshuaGostick
11 - Bolide

Fun quick challenge

 

Spoiler
challenge_234.PNG