Alteryx Academy

I hope you all had fun with last week’s challenge, completing lap one form the Inspire 2016 Grand Prix event (challenge #29).   The solution is posted HERE.   Now that you have your data prepped it is time for Race 1 lap 2, you need to answer some questions so you will have content for your annual "Draft Recap" newsletter.       Objective: Please use Alteryx to answer the following questions –   Who has the youngest team and what is the average age? Which team has the best (lowest) average pitcher rank? What is the Pearson correlation between 2015 Team Rank and Hitter Rank? Please build a table containing the count of players on each fantasy team by position, the sum of home runs for the hitters by fantasy team, and sum of wins for the pitchers by fantasy team, ordered by 2015 team rank.   *Keep in mind the contestants only had about 10 minutes per lap maximum so time yourself. ... View more

The link to last week’s challenge (challenge #28) is HERE   Hi everyone, what an awesome time we had at the Alteryx Inspire 2016 Conference in San Diego last week.  It was so nice to meet many of the Community members in person.  If you attended the conference and went to the Grand Prix event, this week’s challenge is the first of the four laps.  We will cover all of laps as weekly challenges in the next weeks.   See if you have what it takes to compete, keep in mind the contestants only had about 10 minutes per lap maximum so maybe time yourself.   Use Case:  You are the commissioner for your fantasy baseball team. You recently completed your draft and you want to run some simple statistics about each fantasy team.   You have 3 inputs 1) Fantasy pick summary from your draft 2) Hitter stats on all field players (whether selected in your draft or not) 3) Pitchers stats on all pitchers (whether selected in your draft or not)   Objective:  In order to run some stats on your draft, you first need to prep your data. Please combine all 3 files so that you have a single output that contains stats on each player drafted in your draft, ordered by "Overall_Pick."   Drivers start your engines! ... View more

A solution for last week's challenge has been posted here in both video and workflow forms!    This week's Challenge lets you get crafty!  Create an app to allow a user to search a list of craft canned beers by state of origin or beer style.  Configure the app's interface to utilize radio buttons to expose the selection elements for each selection option: a Text Box for searching by state, and a Drop-Down for beer styles.  Feel free to customize the app as you see fit!                ... View more

For the fourth challenge let’s look at parsing Dates from text strings. To view the previous challenge, click HERE.   A dataset contains a text field that has a date embedded within the text. The problem is that the date is represented a few different ways. For example:   16-APR-2005 Nov•16,•1900 4-SEP-00 Jan•5•2000   The goal is to create a new Date/Time field populated with the dates contained within the text field. You will also need to standardize the dates so that they are all formatted the same. We have listed this as an advanced exercise since parsing out the dates can be challenging depending on the technique you employ to do it. As always, we love to hear your comments. Have fun!   UPDATE 12/7/2015: The solution has been uploaded ... 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