Alteryx Academy

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by Douglas Perez, @dougperez . Thank you, Douglas, for your submission!   A company recently hosted an internal Alteryx certification event to promote professional growth and upskilling across the organization. Each participant was assigned to a team, and throughout the event, employees earned various professional certifications.   Now that the event has concluded, it’s time to analyze the results and determine which team came out on top!   You’ve been provided with two datasets: A certifications dataset containing certification records, each with its status (Expires or Expired) and the date. A team mapping dataset linking each participant to their respective team.   Analyze the results and rank the teams based on the number of valid certifications earned by their members. Follow the rules below:   Only include certifications that are currently valid (status is Expires). Focus only on certifications with names that include Alteryx Designer or Server. Exclude any certifications that mention Cloud or Trifacta. Aggregate the results by team and rank them from highest to lowest based on the number of valid certifications.   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: Dataset generated by ChatGPT.   Download Start File Download Solution File  ... View more

The link to last week’s challenge (challenge #40) is HERE   This week’s exercise looks at using Alteryx to calculate the number of weekdays during each pay period.  Employees get paid twice monthly so the number of weekend days within a period can vary.   Objective:  For each month and pay period, calculate the # of weekdays that make up the pay period (i.e. exclude weekend days from the calculation). ... 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 Maveryx,   We posted the solution JSON file to Cloud Quest #7. 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!   Upload the provided Cloud Quest 8 - Start File.json file into your Analytics Cloud library. The input and output datasets are included in the start file.   For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.     Scenario:   A group of friends are playing their favorite game. Not understanding the importance of inputting data in an easy-to-work-with format, they devised an incredibly inefficient way to keep score of their game!   In the game, there are five rounds of play and five players (a, b, c, d, and e—the first letter of their names). Each time the player’s initial appears in lowercase, the player is awarded 1 point. Each time their initial appears in uppercase, 1 point is subtracted from their overall score. Now it is your job to figure out each player’s score for each round and their respective totals after all five rounds of play. Who won?    Hints:  Tokenize the input data into rows. There are many ways to calculate scores for each letter, but an If/Then statement can accomplish this in one expression. When pivoting, you can perform multiple calculations at once including Sum and Total Column. A combination of the Cross Tab, RegEx, Formula, and Dynamic Replace 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 a screenshot of your workflow as attachments to your comment.   Here’s to a successful quest!     ... View more

    Hi Community members,   A solution to last week’s challenge can be found here.    This challenge was submitted by Casey Koopmans @cwkoops. Thank you, Casey, for this interesting challenge!   In global supply chain operations, duty drawback programs allow exporters to reclaim duties paid on imported raw materials once the resulting finished goods are exported. To comply with such programs, companies must maintain traceability between the raw materials used and the finished goods produced. For this challenge, imagine you work with a manufacturer that processes raw materials into finished goods. Each raw material is received in lots, and the manufacturer needs to trace how much of each raw material lot is consumed in each finished good lot, following a strict First In, First Out (FIFO) usage policy. Your task is to develop a FIFO allocation model that maps the consumption of raw material lots to finished good lots, enabling full traceability. You are provided with two datasets: a.        Raw Material Lots: a table that lists all the raw material lots received: b.        Finished Good Requirements: a table that lists each finished good lot and its corresponding raw material requirements:   Each finished good lot consumes a certain amount of a specific raw material type (SUB), which must be traced back to specific raw material lots.   Your task for this challenge: Using FIFO allocation, build an iterative macro that helps determine which raw material lots are consumed by each finished good lot, and how much of each lot is used. To do so, consider the following:   Group raw material lots by ITEM (raw material type) and sort them in the order received. Iterate through each finished good lot in the order produced. For each finished good lot:    - Identify the required SUB (raw material type) and SUB QTY (quantity required).    - Allocate this quantity using the earliest available raw material lots (FIFO).    - Deduct the used quantity from raw lot availability and record which lots were used and how much. Output a table that shows:    - Finished Good Lot ID (FG LOT)    - Raw Material Type (SUB)    - Raw Material Lot (RAW LOT)    - Quantity Used (QTY USED)   Source: Sample Data set provided in the workflow as text inputs.   Good luck! The Academy Team   Download Start File   Download Solution File ... View more