Cloud Quests
Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.
Hi Maveryx,
We posted the solution JSON file to Cloud Quest 9. 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 10 - Start File.json file into your Analytics Cloud library.
- All relevant datasets have been preloaded into Text Input tools.
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:
For this week's quest, you received product data that was, shall we say... interestingly formatted in Excel with key product information stored at the top of the file. Each data column contains three lines of header information per product (product, market, and type). To make downstream analysis possible, reformat this information to be shown in rows for each product.
Hint: If you are used to the configuration terminology of the Transpose tool in Designer Desktop:
- "Key Columns" are called "Columns to Group By" in Designer Cloud.
- "Data Columns" are called "Columns to Transpose" in Designer Cloud.
If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in the Maveryx Academy for guidance:
- Getting Started with Designer Cloud
- Building Connections in Designer Cloud
- Building Your Workflow in Designer Cloud
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!
I did this a few different ways but I decided to upload the one that was the most different from anything else I saw after walking through the spoilers. Efficient? No. Other in the sense that it's copy/paste/tweak for each container (so if it was 100 of them, it wouldn't be fun anymore). But funny? Yes.
