Hi Community,
We posted the solution JSON file to Cloud Quest #35. 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 Start Cloud Quest 35.json file to 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.
Scenario:
The results from a recent conference survey have left you with a parsing challenge! Each attendee’s responses to five survey questions are stored in a single column.
Your task is to parse and restructure the data so that each attendee’s first name, last name, occupation, industry, and attendee information are all contained within a single row.
Hint: Combine the Transpose and Cross Tab tools to reshape the dataset.
Image generated by ChatGPT, June 4, 2025, OpenAI, https://chat.openai.com.
Earn Cloud Quest badges:
After completing your quest, head back to your Analytics Cloud library:
- Download your workflow solution file.
- In your reply, attach both your JSON solution file and a screenshot of your workflow.
- Keep submitting—every solution gets you closer to earning more Cloud Quest badges!
Here’s to a successful quest!
- The Academy Team
Download Start File | Download Solution File
