Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved.
Learn more here!
Dive deeper into solving problems with Alteryx, explore new frontiers in your analytics journey, and push yourself to prove and improve your skills with our Certification Program.
Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.
Also available in...
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
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
A solution to last week’s challenge can be found here.
It's vacation time. Will your flight leave on time?
Are you getting ready for vacation and worrying about the long hours of delay at airports? This is always in the back of our minds as we make a flight reservation, isn't it? Let's look at how bad flight delays were in the summer of 2021, which officially started on June 21 and ended on September 22.
Based on the dataset Flights_2021, which contains a random sample of all the flights in 2021, and the two tables provided, let's find the following information:
1. What were the five top airlines with more delays that summer? 2. What Airline had the longest delayed time that summer? On what date? 3. What were the top five airports with more flights delayed that summer? 4. How many flights were canceled that summer?
Note: CRS_Dep_Time= Scheduled Departure Time (local time: hhmm) Dep_Time: Actual Departure Time (local time: hhmm) Dep_Delay: Difference in minutes between scheduled and actual departure time. Early departures show negative numbers.
Thank you for your comments, this challenge has been updated.
... View more
Hi Maveryx,
Thanks for submitting your solutions for Cloud Quest #2! In the video solution we posted, Alteryx Chief Evangelist Josh Burkhow will guide you through the workflow.
Now, for this week’s quest, let's delve into the task of ranking records when there can be multiple records with the same rank.
Using the provided dataset that contains two columns [Name] and [Count], your goal is to identify the top five rankings based on the count. However, as there might be several rows with identical counts (similar to a round of golf), multiple individuals can occupy the same position (Rank) if they share the same score.
Your final result should look like the following image:
Hint: Identify the top five positions (ranks 1 through 5) based on the Count column before proceeding with your analysis.
A combination of Join, Summarize, Sample, Row ID, and Sort tools should solve your problem, not necessarily in this sequence.
If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in Maveryx Academy for guidance:
Getting Started with Designer Cloud
Building Connections in Designer Cloud
Building Your Workflow in Designer Cloud
Here’s to a successful quest!
We want to hear from you!
As we introduce our Cloud Quests for the first time, we value your input. Share your thoughts on the clarity of instructions, the provided dataset, the expected output, and any suggestions to enhance your experience.
Thank you!
... View more
Hi Maveryx,
We are launching an updated process to submit Cloud Quest solutions!
Starting today and moving forward we will provide a JSON workflow start file for each quest. The workflow contains starting data preloaded into a Text Input tool (or tools).
Upload this JSON file into your Alteryx Analytics Cloud Library, then you can open the file and start solving the quest in Designer Cloud!
Similarly, once you are finished, you can export your JSON solution file to attach to your reply on Community.
Remember to attach your solution file to your reply on Community to get credit towards your Cloud Quest badge count.
Please continue to upload a screenshot of your solution workflow so other Maveryx can check out your creativity!
Review the following instructions to learn how to import and export Alteryx Designer Cloud workflows.
Import the Cloud Quest Start File
Download the provided JSON start file and upload it into your Analytics Cloud library.
Open the workflow in Designer Cloud.
Start solving!
Export Your Solution
Once you have completed your quest, go back to your Analytics Cloud library.
Download your workflow solution file.
Upload your JSON file as an attachment to your comment.
Now, with that out of the way...
Let’s dive into this week's quest!
You are a data analyst at a sports statistics firm. Your department is focused on analyzing historical data from major international sporting events, and your current project is the FIFA Women’s World Cup™.
You have been provided with a dataset named Women’s World Cup dataset. This dataset contains Women's World Cup match records, including teams, match outcomes, and dates from August 2016 through November 2018.
Your goal is to use Alteryx Designer Cloud to process this dataset and determine which team won the most matches during that time period. The outcome should consist of two columns: one for the team and the other for the number of wins.
Hint: Use the IF/THEN expression in the Formula tool to identify the winners. Also, ensure to exclude any matches where there was a tie.
A combination of the Sample, 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
Here’s to a successful quest!
... View more