Alteryx Academy

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

The link to the solution for last challenge #35 is HERE.    Use Case:  An analytical consulting company downloads medical journal publication data from the web and would like to extract all of the authors for the listed entries.   The text input contains details about each article where FAU indicates the author name for the article – in most case there are multiple authors. The details of each article are contained in lines that begin with PMID and end with an empty line.   Objective: Parse out each article PMID and list each author in sequential columns as seen in the Results.yxmd file. ... View more

A solution to last week’s challenge can be found here.   To solve this week’s challenge, use Designer Desktop. Challenge Created by: @PhilipMannering      Description: Based on the data provided, your task this week is to find all possible words in the Spelling Bee puzzle sorted by length (descending). The Spelling Bee puzzle is a grid of seven letters. The rules for valid words are: 1. You must only use letters found in the grid. 2. You must use the center letter at least once in each word. 3. Words must contain at least four letters. 4. Letters can be used more than once. The first input contains the grid of letters. Hint: You will (quite literally) require ALTERYX to find the perfect pangram.     Designer Version Used to Create: 2020.3 ... View more

The link to the solution for last challenge #34 is HERE.  For this challenge let’s practice some data cleansing.   Use Case:  There is a series of data cleansing processes we need to do on our data. Please solve each per the instructions. Objective: Remove leading zeroes Trim leading zeroes and/or descriptive text at the end If the data value ends with ID, remove the ID If more than 8 chars, remove anything after 8. If only 6, add “SC” to the front. ... View more

A solution to last week’s challenge can be found here.   To solve this week’s challenge, use Designer Cloud or Designer Desktop.   Do you have to reformat lists because the last name and first name are listed in a different order?   In this weekly challenge, you need to rearrange an improperly formatted list of subscribers. Some of the subscribers’ names are listed with the last name(s) followed by a comma, and then the first name(s). Your goal is to reorder the list with the first name(s) followed by the last name(s), and put the list in alphabetical order. For example, the subscriber “BORROEL GOMEZ, JUANA” should be listed as “JUANA BORROEL GOMEZ” with no punctuation.   Note that some subscribers can have more than one first name or last name.   Haven’t heard about Designer Cloud yet?  Watch a demo .   ... View more