Cloud Quests

AYXAcademy

Hi Community,

We posted the solution JSON file to Cloud Quest #49. 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 50.json file to your Alteryx One 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:

G'day! A distribution company in Australia needs to align its customer base with specific sales territories. Their source data contains individual customer records with 4-digit postcodes, but their regional definitions are stored as numeric ranges (e.g., Region A covers postcodes 2000 to 2005).

To ensure every customer is correctly accounted for, you must first assign each record to its appropriate territory and identify the associated Sales Rep. Practice your joining and spatial-logic skills to complete the following:

Create a table that summarizes the customer data. The output should show a count of customers grouped by Region, Sales Rep, and Responder Status.

Hint: Since the Alteryx Join Tool only supports exact matches, you will need to find a way to compare the customer postcode to the start and end range boundaries. Consider using the Append Fields tool followed by a Filter tool to isolate the matches, or use the Generate Rows tool to expand the lookup table into individual postcode rows for a standard join.

Image: Generated by Google Gemini, Jan 7, 2026, google.gemini.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!