Alteryx Academy

Hi Maveryx,   We posted the solution JSON file to Cloud Quest #5. 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 start file and upload it into your Analytics Cloud library. For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article .     Scenario:   This week’s quest revolves around data provided about standardized math exams administered in New York City Public Schools from 2013 to 2019. Download the provided district_math_results.csv dataset and reconnect it in your starting workflow file. Ensure that the Interpret Column Datatypes checkbox is not selected in the Input Data tool options. The dataset includes details on the district, grade, year, category (male/female); the number of students who took the test; and the percentage of students who achieved each level, with Level 4 being the highest.   You have two tasks: Calculate the change, by district, in the percentage of 8th grade female students who achieved a Level 4 score in 2019 compared to 2013. Identify the top three districts that showed the most significant improvement in the Level 4 percentage over the same period.    Hint: Configure the Cross Tab tool to create a new column based on the Year field, labeling the columns as Year 2013 and Year 2019. The Level 4 percentage should serve as the value for these columns, using the Use First Value method. Ensure the data is grouped by District.   A combination of the Sample, Filter, Cross Tab, Formula, and Select tools should solve your problem, but not necessarily in this sequence. A combination of the Sample, Filter, Cross Tab, Formula, and Select tools should solve your problem, but not necessarily in this sequence.   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 workflow screenshot as attachments to your comment.   Here’s to a successful quest!       Source: https://infohub.nyced.org/docs/default-source/default-document-library/2014-15-to-2022-23-nyc-regents-overall-and-by-category---public.xlsx ... View more

A solution to last week's challenge can be found here.    This week's challenge was submitted by @MarqueeCrew  based on this post - Thanks for your submission! Be sure to check out the accompanying blog post!   In this challenge we need to create a workflow to remove vowels from text, excluding vowels that are the first letter in a word. Y is included as a vowel for this challenge... ... 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

    Hi Community,   We posted the solution JSON file to Cloud Quest #48. 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 49.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:   Happy Holidays! 🎄 This dataset contains the top 40 most populous countries and a list of federal / national holidays observed by each in 2025. Practice your parsing and data cleansing skills to answer the following questions:   1. Which country observes the highest number of federal holidays in 2025, and how many does it have? 2. "Unique holidays" are dates where only one country in this list has a day off. Which country has the most of these exclusive holidays, and what is that count? 3. On which specific date do the most countries in this list share a holiday? List the date and the names of the sharing countries.   Hint: While the holidays and dates are separated by clear delimiters, use the Tokenize method within the RegEx tool to split them into rows for an added parsing challenge. Dataset: Generated by Google Gemini, Dec 23, 2025, 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 | Download Solution File     ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by Ashley Talay, @aatalai. Thank you, Ash, for this delightful seasonal puzzle!   As the snow begins to fall and the year comes to a cozy close, it’s the perfect time for a bit of holiday fun. While the Elf on the Shelf is busy reporting back to Santa, another mischievous character has gone missing...   Waldo (or Wally, depending on where you’re celebrating) has snuck off for a little hide-and-seek adventure. Guess where? Inside an Excel folder, of all places!   He's somewhere deep within the "Places" directory, but he’s layered himself under folders, subfolders, and buried sheets, a classic Waldo move. We don’t know: Which folder he's in, Which subfolder he chose, What file he’s hiding in, Or even which sheet he’s nestled on.   Your mission (should you choose to accept it under the twinkling lights of December): Find Waldo!   Dig through the maze of folders and spreadsheets, and tell us exactly where he is hiding: Folder Subfolder File name Sheet name   If you feel it’s time to showcase your macros skills, you can level up and dive even deeper.   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   Places Zip File   Download Solution File   ... View more