Learn

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, it is a continuation from last week’s warehouse distribution challenge. If you did not complete last week’s challegne don’t worry, you will not need any output from part one to complete this part.  The link to the solution for last week’s challenge is HERE. I posted two solutions for last week’s challenge. The first is a solution without a macro and is in my opinion a more straight forward approach to solving the problem. I included the second macro approach because it is an excellent example of how to utilize an iterative macro.   The use case:   Based on data from last week’s warehouse distribution challenge , we want to calculate the total shipped miles per item. The products are available from 3 different warehouses, lat/lon data is provide for each warehouse and each store location.   Your goal is to find the total distance travelled as straight line miles for each item based on it being shipped from the closest warehouse.   Good luck, I hope you are having fun with these challenge  and expanding your knowledge of Alteryx. Thanks to all that have provided feedback. ... View more

Congratulations on completing Exercise 3!    When you are ready to submit your solution, click "Reply" to this post and upload your workflow.   You may also download and review the attached solution. ... View more

The link to last week’s challenge is HERE.     Happy thanksgiving to the USA based challenge participants, hopefully you are hungry for another exercise.  This week we will continue with some more data parsing and preparation with survey data.  Enjoy!   Use Case:  The 2 sources of data contain survey information. The Data input contains all of the survey responses. The Questions input contains the associated questions.   The column (called Column) in the Questions file corresponds to the field header value in the Data file, so value 38 in the Questions files is the questions associated with field F38 in the Data file.   The first row in the Data file contains the response type. In field F38, the data is formatted as Response (Scale 1-10) - Age Range.   Objective:  Create an output file for a visualization tool (Tableau, Qlik, PowerBI) that details the response by age for each individual. ... View more

Aggregate Consumer Purchases: For this week’s exercise we will look at customer purchase behavior to decide if we should offer a “Meal Deal” that would add a side and drink to a purchase of pizza or a burger. The incoming data is larger than usual for these exercises so I have packaged the workflow as an Alteryx Package. The link to the solution for last challenge  #7 is HERE.   This week’s Objective: In order to decide if we should start including a new "Meal Deal" on our menu we want to study the potential impact on recent transactions. Please identify the number and percentage of orders since July 1, 2013 which include the following categories of food: Pizza OR Burger along with a Side and Drink.   Summary of Data: Point of Sale data includes the ticket level information, and the lookup table categorizes items into higher level food categories.   Hint: Don't forget to join to the lookup table and filter by date.   As always we look forward to your feedback and suggestions!   UPDATE 01/18/2016: The solution has been uploaded.   UPDATE 12/28/2016: The challenge , text and solution have been updated. ... View more