Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

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
22 - Nova
22 - Nova

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
16 - Nebula
16 - Nebula

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
Alteryx
Alteryx

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

 

Spoiler
JustinBabbitt_0-1600697723454.png

 

Justin Babbitt