Alteryx Academy

Happy New Year, Community Members!   A big thank you to Erin Miller (@Erin)  for this special submission. Erin, you've contributed so many fantastic challenges throughout 2025, and it’s only fitting that Challenge #500 comes from you. We truly appreciate your creativity and dedication. Thank you again!   A solution to last week’s challenge can be found here.   It’s 2026: time for resolutions, fresh routines, and rethinking your media diet.   Your friend has been deep into true crime podcasts, so deep, in fact, that their spouse is starting to give them some serious side-eye. It’s clearly time for a change: something lighter, brighter, or just totally different.   Luckily, you’ve come across a daily dataset of Spotify’s Top 200 Podcast Episodes, complete with detailed show and episode info from the Spotify API. What better way to kick off the new year than with a chained analytic app to help your friend discover their next podcast obsession?   Your 2026 Podcast Discovery App – Let’s Build It!   Create a chained app experience where each selection refines the next. The app should include the following filters:   App 1 – Filter by Region App 2 – Filter by Language (Feeling a little extra? Let the user select multiple languages!) App 3 – Filter by Average Podcast Duration (Really feeling extra? Group durations into 15-minute intervals for a smooth user experience!)   After all filters have been applied, calculate the average show rank and identify the top-ranked episode for each show. The final result should include a summary of the selected filters and a table displaying the top 10 shows by average rank, along with the show description, average show duration, publisher, highest-ranked episode, and episode description.   Did you know that Alteryx has a podcast within the Alteryx Community? Check out the Alter Everything Podcast here: https://community.alteryx.com/t5/Alter-Everything-Podcast/Alter-Everything-Podcast-Episode-Guide/ba-p/450065    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/daniilmiheev/top-spotify-podcasts-daily-updated    Download Start File ... View more

Happy Monday… oh wait it's Tuesday already.  Sorry for the delay if you are an international Alteryx community member, yesterday the USA and Canada celebrated Labor Day in honor of working people.   Hopefully everyone had fun debugging the Macro last week, the link to the solution for that challenge (#39) is HERE.  For this week we look at what needs to be done to process raw HTML data after using the download tool to scrape the web.    One of the features of the Alteryx download tool is that it can pull down the raw HTML code from a web page.  This practice sometimes referred to as web scraping is useful when there is embedded data in the page you want to access from Alteryx.  The challenge is that the raw HTML needs to parsed to prepare the data for use.   Use case:  5280 Magazine in Denver published a list of the best doctors in the Denver metro area, you need to download that list in database form. (Note the Raw HTML has been provided in the workflow)   Objective:  Parse the HTML into a database format containing fields for the ID, Physician, Address, City and Practice   Good luck, I hope you are having fun with these challenges and expanding your knowledge of Alteryx.  Thanks to all that participate and have provided feedback. ... 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,   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 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