topic Re: Cloud Quest #31: Place Value Chart in Cloud Quests

Cloud Quest #31: Place Value Chart

mikecusic — Tue, 03 Feb 2026 20:49:42 GMT

Hi Community,

We posted the solution JSON file to Cloud Quest #30. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!

Let’s dive into this week's quest!

Download the provided JSON file containing your starting data and workflow files.
Upload the provided Cloud Quest 32 Start.json file into your Analytics Cloud library.
All necessary datasets are contained within Text Input tools in the workflow.

For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.

Scenario:

In Alteryx Designer Cloud, continuous numeric values are left-aligned by default, which can make it difficult to visually compare numbers with different digit lengths.

In this week’s Cloud Quest, your task is to reformat the given [Amount] column so that each digit—including the decimal point—is placed into its own separate column, ensuring that all decimal places are perfectly aligned. Each numeric value should have 2 decimal places.

By the end, your output should be a structured table where numbers are visually easier to compare at a glance.

Source: https://www.mashupmath.com/blog/expanded-form-with-decimals

Bonus: Make your workflow dynamic to accommodate any incoming [Amount]. Assume a maximum of 2 decimal places.

Hint: Ensure [Amount] values have two decimal places before counting digit lengths.

If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in Alteryx Academy for guidance:

Once you have completed your quest, go back to your Analytics Cloud library.

Download your workflow solution file.
Include your JSON file and a screenshot of your workflow as attachments to your comment.

Here’s to a successful quest!

- The Academy Team

Re: Cloud Quest #31: Place Value Chart

ggruccio — Wed, 02 Apr 2025 17:52:19 GMT

Got the bonus logic to work!

...but I had converted all values to text to pad them, and then when creating the results by column each digit needed to be converted to a numeric value. Not sure how dynamic I could make the field conversions because the decimal point would not always be in the same field depending on the maximum length of the dataset.

Re: Cloud Quest #31: Place Value Chart

alexnajm — Wed, 02 Apr 2025 19:28:46 GMT

Got the bonus as well @ggruccio !

Re: Cloud Quest #31: Place Value Chart

RWvanLeeuwen — Thu, 03 Apr 2025 08:27:42 GMT

Here's my take

Re: Cloud Quest #31: Place Value Chart

Carolyn — Thu, 03 Apr 2025 16:42:27 GMT

Solved! This should accommodate any numbers to the left of the decimal (and assumes 2 to the right, as per the instructions)

Re: Cloud Quest #31: Place Value Chart

JeffF — Mon, 07 Apr 2025 22:46:27 GMT

Re: Cloud Quest #31: Place Value Chart

Qiu — Fri, 11 Apr 2025 01:30:26 GMT

I like this one.

Re: Cloud Quest #31: Place Value Chart

patrick_digan — Fri, 11 Apr 2025 18:43:46 GMT

Re: Cloud Quest #31: Place Value Chart

AkimasaKajitani — Sat, 19 Apr 2025 02:26:53 GMT

Here is my dynamic decimal solution.

Re: Cloud Quest #31: Place Value Chart

mkeiffer — Wed, 30 Jul 2025 16:11:36 GMT

Here is my solution, with the Bonus portion included.

Re: Cloud Quest #31: Place Value Chart

Erin — Wed, 30 Jul 2025 22:55:41 GMT

Betreff: Cloud Quest #31: Place Value Chart

RolandSchubert — Thu, 11 Sep 2025 08:56:39 GMT

Re: Cloud Quest #31: Place Value Chart

bradshaw — Sat, 27 Sep 2025 11:05:51 GMT

Re: Cloud Quest #31: Place Value Chart

SGolnik — Fri, 31 Oct 2025 11:49:06 GMT

Another one done!

Re: Cloud Quest #31: Place Value Chart

RebekaMazuchova — Thu, 26 Feb 2026 14:26:47 GMT