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.
Review the following instructions to learn how to import and export Alteryx Designer Cloud workflows.
Import the Cloud Quest Start File
Export Your Solution
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 Womens World Cup dataset. This file contains detailed Women's World Cup match records, including teams, match outcomes, and dates from 2016 through 2019.
Your goal is to use Alteryx Designer Cloud to process this dataset and determine which team won the most matches in years 2016-2018. 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.
If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in the Maveryx Academy for guidance:
Start file in json format is really nice to start the quest with!
Love the new process!
Here's my solution!
Done with this one.