topic Re: Cloud Quest #24: Meta Parsing in Cloud Quests

Cloud Quest #24: Meta Parsing

AYXAcademy — Tue, 03 Feb 2026 20:51:49 GMT

Hi Community,

We posted the solution JSON file to Cloud Quest #23. 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 #24 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:

This week’s quest is all about creating a workflow that can adapt to different incoming data schemas. The starting datasets contain strings of letters that can be parsed into words of different lengths based on various character starting positions within the string. Create a process that automatically parses the data from Dataset A using the parsing instructions provided. Once you create the workflow, you should be able to replicate your process for Dataset B by copying and pasting your tools.

Hint: If you are stuck, start with an Append Columns tool.

A combination of the Cross Tab, Formula, Select, and Append Columns tools should solve your problem, but not necessarily in this sequence.

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 as an attachment to your comment.

Here’s to a successful quest!

Re: Cloud Quest #24: Meta Parsing

JeffF — Tue, 24 Dec 2024 19:06:58 GMT

Re: Cloud Quest #24: Meta Parsing

Qiu — Wed, 25 Dec 2024 00:38:02 GMT

Fun one.
Using the Length to configure the column position is the trick.

Re: Cloud Quest #24: Meta Parsing

ggruccio — Thu, 26 Dec 2024 20:38:08 GMT

There may be an easier way to sort the columns numerically, but it works!

Re: Cloud Quest #24: Meta Parsing

alexnajm — Sat, 28 Dec 2024 18:40:06 GMT

Done!

Re: Cloud Quest #24: Meta Parsing

KLTerrell — Sun, 29 Dec 2024 18:30:44 GMT

I did this with RegEx, so I'm not sure if I missed the boat - but it seemed like the quickest way. My rows are not in the same order as the Output Solution, but the data matches... I couldn't figure out the common thread of how the rows are sorted in the Output Solution.

Re: Cloud Quest #24: Meta Parsing

AkimasaKajitani — Tue, 31 Dec 2024 09:05:30 GMT

My solution!

However I can't download my solution from AAC. Something wrong.

Re: Cloud Quest #24: Meta Parsing

patrick_digan — Fri, 03 Jan 2025 15:44:29 GMT

Re: Cloud Quest #24: Meta Parsing

RWvanLeeuwen — Tue, 07 Jan 2025 09:07:47 GMT

Here we go!

copy pasting tools is part of this Quest

Re: Cloud Quest #24: Meta Parsing

Carolyn — Fri, 17 Jan 2025 20:03:32 GMT

Solved

Gotta love the Substring formula!

Re: Cloud Quest #24: Meta Parsing

JoshuaB — Tue, 18 Mar 2025 18:05:47 GMT

Fun challenge!

Re: Cloud Quest #24: Meta Parsing

gita_ligure — Tue, 18 Mar 2025 18:20:52 GMT

Learned something new, for sure!

Re: Cloud Quest #24: Meta Parsing

marcinzegrodzki — Wed, 19 Mar 2025 08:07:47 GMT

Re: Cloud Quest #24: Meta Parsing

JShaheen — Thu, 03 Apr 2025 14:17:22 GMT

Another good one!

Re: Cloud Quest #24: Meta Parsing

AkimasaKajitani — Sat, 17 May 2025 02:38:19 GMT

My solution(File only). My screen shot was already uploaded.

Re: Cloud Quest #24: Meta Parsing

Tonya_Smith — Tue, 20 May 2025 20:23:04 GMT

my solution

Re: Cloud Quest #24: Meta Parsing

DavidDom — Wed, 11 Jun 2025 20:40:12 GMT

Solved :)

Re: Cloud Quest #24: Meta Parsing

bradshaw — Fri, 13 Jun 2025 11:22:50 GMT

Re: Cloud Quest #24: Meta Parsing

Erin — Sat, 26 Jul 2025 03:29:35 GMT

Re: Cloud Quest #24: Meta Parsing

mkeiffer — Mon, 28 Jul 2025 01:23:24 GMT

Here is #24!