Learn

    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

We hope you enjoyed last week's challenge. The solution has been posted here. For the second challenge lets look at removing characters and splitting data into columns based on delimiters.   Many products will export textual data with delimiters such as quotes. This is done so that strings can contain delimiters or control characters within them. Having more than one type of delimiter can be hard for ETL programs to interpret.  In the input text file, there are two different delimiters (double quotes, single quotes) and they surround different data types.   Use Alteryx to strip out the delimiters as superfluous and format the data as represented in the output.   You may notice that we have started classifying the exercises into beginner, Intermediate and advanced.  This classification is used by Alteryx internally to sequence exercises as users advance.    Update 11/23/2015: The solution has been uploaded. ... View more

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