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

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found hereSource: https://www.mashupmath.com/blog/expanded-form-with-decimalsSource: https://www.mashupmath.com/blog/expanded-form-with-decimals

 

This week's challenge is a two parter that will include a follow up challenge next week. For now, we dig into part 1!

 

If you've ever worked with continuous variables in Designer, you may have noticed that the values are left justified in the Results Window. This can make it a little more difficult to read your dataset. Convert the values provided into a table that lines up the decimals and has only one character per cell.

Aaron_Harter
11 - Bolide

Looking forward to Part 2 next week!

Spoiler
234.1.PNG

(edit 9/21 9:35 CT) video of solution overview:

Spoiler

 

 

atcodedog05
17 - Castor

Done and solved. Fun challenge : )

 

Spoiler
atcodedog05_0-1600693600857.png

 

Cheers and Happy Analyzing : ) 

Blake
12 - Quasar

I was able to make my solution dynamic so it can take as large of a number as needed but will  only handle 2 decimal places for now. Maybe I'll be able to beef it up for next week!

 

Spoiler
Blake_0-1600697057407.png

 

 

 

 

etzele
8 - Asteroid

So do I!

 

Spoiler
etzele_0-1600694432275.png

 

jeng
8 - Asteroid
Spoiler
Time for regex!
jeng_0-1600695271991.png

 

hlmess
7 - Meteor

I was able to make mine dynamic for the number of digits to the left and right of the decimal but I'm 100% sure there's a simpler way to do it.

Spoiler
hlmess_0-1600697010826.png

 

 

PaulFound
11 - Bolide
Spoiler
PaulFound_1-1600697190611.png

 

Now I have to wait until next week ???? :,(

RolandSchubert
15 - Aurora
15 - Aurora

Interesting challenge. I tried to make it flexible by identifying the number of pre-decimals and decimals in a first step and filling/splitting the result in a second step.

 

 

Spoiler
234.png
JustinBabbitt
10 - Fireball

I'm looking forward to seeing how other solve this! 

 

Spoiler
JustinBabbitt_0-1600697723454.png