Alteryx Academy

    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

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by Erin Miller. Thank you, @Erin , for another great challenge!   According to Erin, someone who wins at Mario Kart seems to know every shortcut and trick, and it’s easy to assume they’re always choosing the perfect character and kart combo. But not anymore! We now have access to in-game data for every driver, kart/body, tire, and glider in Mario Kart 8 Deluxe.   Using the datasets provided, the mission is to identify the most optimal combinations that deliver the best overall racing performance.   What You Need to Do Compute the average value for each stat category (speed, acceleration, handling, etc.) across each individual dimension: driver, kart/body, tire, and glider. Determine the average stat values for every combination of driver, kart/body, tire, and glider. For example: What is the average speed for a specific driver when paired with a given kart, tire, and glider? For each combination, calculate a total weighted average using the provided weights table (or create your own!) to reflect the relative importance of each stat.   The final output should include each driver–kart–tire–glider combination, the corresponding average stat values, and a total weighted score.   Feeling a Little “Extra”? Use a macro to automate repetitive tasks (such as calculating averages).   Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.   Good Luck! The Academy Team   Source: https://www.kaggle.com/datasets/marlowspringmeier/mario-kart-8-deluxe-ingame-statistics   Download Start File Download Solution File   ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by John Primeaux (@jeprime) . Thank you, John, for your submission!   This week, you’re stepping into the role of a data quality detective. A data table has been populated with critical tracking codes—but many of them have been entered incorrectly.   Each code is supposed to follow a very specific structure. This format is vital because these codes are used to locate corresponding documentation within a larger database. Your mission: clean them up and restore order.   The required format is 1 to 4 alpha characters, a hyphen, 3 digits, a hyphen, 2 digits, then one optional alpha character.   The numeric portions (3-digit and 2-digit groups) are always generated correctly by the system. However, delimiters (- vs. _) may be missing or incorrect.   Hint: Assume that the three digits and two digits inside the code are created by a computer; therefore, the hyphen is never missing.   Task 1: Create the code in the correct format (using only hyphens "-"), including the optional letter suffix, and compare it to the old code.   Task 2: Calculate the percentage of codes with a letter suffix, as well as the percentage of codes that are missing or contain incorrect delimiters.   Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.   Good luck! The Academy Team   Download Start File | Download Solution File   Source: Dataset generated by challenge creator. ... View more