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

8 - Asteroid

I took a very non-dynamic, although extremely simple, route that will work for amounts less than one billion.

Spoiler
Two tools.

7 - Meteor

I made this as dynamic as I could think to with the only assumption being that we won't go below the cent level.

It's needlessly complicated and there are many potential improvements but it's very flexible as is with nothing really hardcoded.

Spoiler

8 - Asteroid

Spoiler

There's commonality between field logic:
1 & 4 & 7
2 & 5 & 8
3 & 6
Seems there is a solution with Dynamic Replace somewhere but don't have the time for a second solution. The attached solves the challenge. Looking forward to seeing more efficient ways to solve from the community.

13 - Pulsar
Spoiler
I created the logic for cents, then dollars and hundreds of dollars, then repeated for thousands and millions.

Alteryx

Here's my solutions. Not hard to get an answer, but it's pretty tedious. I sacrificed some efficiency in an effort to make this easier to follow. Next step would be to adjust "dollars" and "cents" to account for "one dollar" or "one cent." to do that I would probably test the original values from the first exercise instead of mucking around with the number broken into columns.

Spoiler
7 - Meteor

After having gone through the exercise, I probably could reduce the number of formulas but this works with just a few tools.

Spoiler

8 - Asteroid

Spoiler

After a while, I gave up and used @RolandSchubert's solution as a reference. I'll have to try again after a couple days and see if I can do it on my own.

This one was hard for me, but fun.

15 - Aurora
Spoiler

17 - Castor

Man, that is a lot of Formula...

Spoiler

12 - Quasar

Wokflow could be simplified more. Used formula is not complicatd but many tool are used.

Spoiler