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.
alteryx Community

# 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

Alteryx

A solution to last week’s challenge can be found hereSource: 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.

11 - Bolide

Looking forward to Part 2 next week!

Spoiler

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

Spoiler

17 - Castor

Done and solved. Fun challenge : )

Spoiler

Cheers and Happy Analyzing : )

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

8 - Asteroid

So do I!

Spoiler

8 - Asteroid
Spoiler
Time for regex!

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

11 - Bolide
Spoiler

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

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
10 - Fireball

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

Spoiler