Alteryx Academy

A solution to last week's challenge can be found here.    This week's challenge was submitted by @kelly_gilbert   - Thank you for your submission!   I bought a lighted marquee box to decorate my office, and I have had a lot of fun updating the message. However, it takes a long time to sort through the letter tiles to see if I have enough for the message I have in mind.   For this challenge, please build an app that will make sure that I have enough of each letter for my desired message. Note, some tiles can be used for multiple characters (e.g. 6 and 9, O and zero).   You don't need to check the message for fit (although, if you want an extra challenge, my marquee box can hold three rows of eight tiles). ... View more

A solution for last week's challenge can be found here.   For this  week's challenge, you are provided two datasets:   - The first one (Clients) contains each client's information including their Client ID - The second one (Request & Evaluation) contains the client's Request number (which is the same as the Client ID),  "Status" which indicates if the request has been processed, "Status2" provides a comment, and the "Professional"  field is the name of the customer.   Your tasks are to determine: - For a "Status" of Evaluated, the number of customers ("Professional") who commented "Below Expectations", "Exceeded Expectations", or "Met Expectations" for "Status2" - The three customers ("Professional") who provided the highest average rating ... View more

A solution to last week’s challenge can be found here.   Because having a reliable electricity source is important to many people, we tend to notice when the power goes out! While we might expect service outages during severe weather events and other natural disasters, sometimes the culprit is... fluffier and cuter, or slithers.   Using the provided dataset, find out: • How many outage events can we attribute to animals? List the culprits with the count of events in descending order.   Hint Use the animals listed in the "Operative" field and information from the "Article Title" field to replace values of "Animal" with the actual animals.   Note All animal types present in this dataset are included in the "Operative" column. ... View more

A solution to last week's challenge can be found here. This dataset contains a list of holiday dates that are observed by each country from Feb. to Dec. 2020. Your Challenge is to figure out for that period: - Which country has the most holidays and how many? - Some holidays are only observed by one country. Which country has the most unique days off and how many? - Which day is the most shared in the world as a holiday and which countries are sharing this holiday? ... 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       ... View more