Alteryx Academy

Hi Community!   We posted the solution JSON file to Cloud Quest #17. 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 the provided Cloud Quest 18 Start.json file into your Analytics Cloud 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 Update.     Scenario:   You work for a company that has offices in the US and Australia. You want to produce a list for staff to reference when either office is closed for a government holiday so they will know not to expect communications that day.   In the US, if a holiday falls on a Saturday, offices will be closed the preceding Friday. If the holiday falls on a Sunday, employees will have the following Monday off.   In Australia, if a holiday falls on either Saturday or Sunday, employees will have the following Monday off.   Using the provided datasets of US and Australian (AUS) holidays in 2024, complete the following tasks:   Produce a table that lists the date, day of the week, and name of the 2024 holidays for both offices. Determine the total number of business days in Australia and the US in 2024.   Hint: Create a Text Input tool with the Start Date (2024-01-01) and End Date (2024-12-31) and add a Generate Rows tool to establish a list of all calendar dates in 2024.   A combination of the Summarize, Filter, Find Replace, Formula, Join Multiple, and Generate Rows 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 Alteryx 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,   We posted the solution JSON file to Cloud Quest #16. 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 the provided Cloud Quest 17 Start.json file into your Analytics Cloud 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 Update.   Scenario:   Marie lives in Toronto, Canada. Every spring, as soon as the weather permits it, she rides her bike to work. Her office is about 15 km away from her home if she drives her car, and a 12 km ride if she bikes.   On Tuesdays and Thursdays, Marie works remotely. On Mondays, Wednesdays, and Fridays, she has to go to into the office. If the temperature gets up to 28 degrees Celsius, she drives to work.   Use the dataset to determine: - How many days did Marie bike and drive in April, May, and June 2021? - How many kilometers did Marie bike and drive in April, May, and June 2021?   Use the “Max Temperature” information provided in the dataset. Note: If the Max Temperature is NULL, assume it is a driving day.   ** Data source: https://climate.weather.gc.ca/climate_data/daily_data_e.html?StationID=51459   A combination of the Filter, Summarize, and Formula 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

 The solution to last week's Challenge has been posted here!   We are thrilled to present another Challenge from our “Think like a CSE” series, brought to you by our fearless team of Customer Support Engineers. Each month, the Customer Support team will ask Community members to “think like a CSE” to try to resolve a case that was inspired by real-life issues encountered by Alteryx users like you! This month we present the case of the hard-coded workflow.     Below, we’ve provided the information that was initially available to the Customer Support Engineer who resolved the case. It’s up to you to use this information to put a solution together for yourself.   The Case: A client’s co-worker has built a workflow that returns a date range between a selected Date (Date1) and the date (Date2) that is x days prior to Date1, as well as all the dates between Date1 and Date2.  The workflow (attached to this post) is great!  It returns all the information she needs for her analysis in the format she wants.  The problem?  Running the workflow requires a cumbersome amount of hard-coding values.  She needs to manually update a Filter tool to select her date range:  Ugh....I had to type this whole thing, and I have to change it every time I want to use a new set of dates!   and a Text Input tool to enter the number of days as a range (1 - x) prior to her selected date to find:  I had to type every one of these numbers! What if I wanted to return much more than 7 days?  There has to be a better way to get the data she wants!     Explanation of the Problem:  The client would like the ability to dynamically select date ranges and the number of days (e.g. 5, not as a range) preceding the selected date.  Can this be done?    Asset Description: The client has shared the workflow she uses, which includes a calendar selection macro (ClientWorkflow.yxzp).    Bonus Question: Is there a way for each date from the date range selected (Date1) to be processed, one at a time?   ... View more

Hi Maveryx,   We posted the solution JSON file to Cloud Quest 15. 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 workflow. Upload the provided Cloud Quest 16 Start.json file into your Analytics Cloud 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 Update.   Scenario:   NOTE: Designer Cloud Standard Mode is required to complete this quest.   You are working as a data analyst in the automotive industry. You need to build a process to validate vehicle identification numbers (VINs) to test for data quality issues across vehicle fleet data. The algorithm that validates VINs is explained in the Check-digit calculation section of the following wiki link.   http://en.wikipedia.org/wiki/Vehicle_identification_number   Your task is to take the VINs from the VIN List Input and create a new column for the check digit. The check digit is always the 9th character in the VIN. Compare the check digit with the calculated check digit value. If the two values do not match (and there was no error in the calculation), then there is a mistake in the VIN. Out of the six VINs provided, how many vehicles have a valid VIN?   The relevant lookup tables have been provided.   Hint: Use the function Mod([Sum_Product], 11) to compare against the VIN check digit as explained in the Wiki article.   A combination of the Summarize, Transpose, Join, Formula, Filter, and RegEx 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 two-part challenge was submitted by Guilherme Dias, @3I_ATLAS. Thank you, Guilherme, for your great submission!   In the previous challenge, you have already identified critical production trends and model behaviors for electric vehicles. Now, shift your focus to innovation and decline — two sides of product lifecycle in the EV industry.   In the second part of this challenge, you analyze which years saw surges of new model launches and which saw waves of production extinction. Reminder: Only include years from 2010 to 2024 in your analysis, as 2025 data is incomplete.   Here are the two tasks you need to accomplish:   Determine which two years had the most distinct new models launched and from which brands were these models launched. Identify the year with the highest number of distinct models that stopped being produced, relative to the prior year. Count each model that was produced in year Y but not in year Y+1 as “extinct,” even if it returns in later years.   You are provided with one dataset (the same dataset from part 1 of this challenge): Electric Vehicle Data – provides the model year, manufacturer (brand) and car model.   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://catalog.data.gov/dataset/electric-vehicle-population-data   Download Start File   Download Solution File ... View more