Alteryx Academy

A solution to last week's challenge can be found here.     This challenge comes to us from @EW  - thank you for your contribution!   A group of friends can't decide on a movie theater at which to see a movie. Given the locations of their apartments and major movie theaters in the area, determine the top three movie theaters to minimize total distance traveled in one direction.  Create a map with the theater and home locations.    Source: GIPHY     ... View more

A solution to last week's challenge can be found here!    This challenge was created for a HackCU hackathon event in which teams were formed and were given 24 consecutive hours and Alteryx Designer to solve the challenge.   In this challenge you must break apart the given [encoded_string] into two character pairs and then build a decoder table, mapping the two-character pairs into ASCII characters to reveal a pig-latin encoded document.   To solve, or not to solve: that is the question.   ... View more

    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!   Here’s to a successful quest! - The Academy Team     Download Start File     ... View more

I know you guys are as excited as I am for another question from the Grand Prix! This one was also from the prelims for the US Grand Prix. This week, we are focusing on calculating time that has elapsed between emails, but the data need some cleansing first.   Congrats to our Finalists that were announced last week! ... View more

A solution to last week's challenge can be found here.  Source: https://www.flickr.com/photos/wkulicki/4010582747/   Did you know that professional golf tournaments start on Thursday and last through Sunday. The players compete on the first two days and only the players with the best scores are allowed to finish the tournament. This is referred to as "making the cut" and it comes with real consequences...money! Players who don't make the cut do not get paid, while everyone who completes the tournament receives a payout based on their final rankings in the tournament.   For this week's challenge, use the included dataset (which contains tournament results for the last 5 years) to find the 5 players with the highest earnings per event, and the top 5 players who have earned the most money without winning any events. ... View more