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

NicoleJohnson
ACE Emeritus
ACE Emeritus

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
ACE Emeritus
ACE Emeritus
Spoiler
jdunkerley79_0-1601110257693.png

 

kelly_gilbert
13 - Pulsar

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
11 - Bolide

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