alteryx Community

# 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.

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

22 - Nova

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 ???? :,(

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
Alteryx

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

Spoiler

Justin Babbitt