Challenges & Quests

A solution to last week's challenge can be found here!    Using the data provided in the start file, create an ordered list of the provided unofficial holidays.       GIPHY  Get ready for Answer the Phone like Buddy the Elf Day on December 18!  ... View more

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 ... View more

  Hello Community members!   A solution to last week’s challenge can be found here.   Thank you, @Qiu , for creating this fun challenge. Your submission was so extensive, we had to divide it into two parts! We appreciate your contributions to our Weekly Challenges!   Welcome to the first of two challenges where you will dive deep into the world of LEGO®! Get ready to uncover some cool facts about LEGO sets, themes, and part counts. Use the provided datasets to solve this challenge. Let’s go!   The datasets contain the following information: sets.csv: Data on LEGO sets, including a unique set number, name, release year, theme ID, part count, and image URL. themes.csv: Data on LEGO themes, with each theme having a unique ID, a name, and a reference to its parent theme when applicable. You have three tasks to complete in this challenge: Determine which LEGO set contains the largest number of parts. Determine which LEGO theme has the largest number of sets. Calculate the average number of parts per set for each year. Use integer as the data type for this task. Good luck! The Academy Team   Download Start File   Download Solution File   Data Sources: https://rebrickable.com/downloads/ https://www.kaggle.com/code/andycapp29/best-bang-for-your-buck-lego-dataset-analysis/notebook ... 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

Here is a new challenge for this week. The link to the solution for last week’s challenge is HERE. The use case: We received some text data and that includes an embedded line-feed character. The objective is to remove the new line character, convert the date-time string to a date-time formatted field and then do some renaming per the sample output. Good luck, I look forward to your feedback. ... View more