Alteryx Academy

For this week’s challenge we can look at using Alteryx to automate a repetitive task.   The link to last week’s challenge ( challenge #18) is HERE. Use Case: Customer has 100's of xls files with 1 common sheet available in all workbooks. Through one process, the user would like to read across all of the xls files and return the values contained in specific cells - Row 2, Column 3 and Row 8, Column 2 for each sheet within each XLS workbook. The result should be a table OR browse tool containing 3 columns: XLS File, Row2_ Column3, and Row8_Column2. You will only have 2 xls files for this challenge , Book1 and Book2, but keep in mind that the use case is for 100s of Excel files with the same schema.  You won’t want to use 2 input tools since that would not scale to 100’s.  Also, for all data consumption, please check the box for First Row Contains Data.  This is because in the headers for an Excel file are in row #1. Good luck and keep it simple, this should be an easy challenge ! ... View more

A solution to last week's challenge can be found here.    Challenge 200 represents another milestone (and badge!) on the trek up Mt. Everest: the arrival at Camp 4.  To celebrate officially entering the Death Zone, we're serving up a challenge created by puzzler extraordinaire @TerryT!    Sudoku is a popular puzzle that requires you to the cells in a 9×9 grid with digits so that each row, each column, and each of the nine 3×3 boxes (shown with heavier lines) contains all the digits from 1 to 9 exactly once. Each puzzle is encoded as an 81 character string.   This challenge has three solution levels:   BEGINNER: Using the Beginner and Intermediate Start File, parse the puzzle by separating rows nine characters at a time. The columns and boxes then line up accordingly where a ‘0’ represents an empty cell.   INTERMEDIATE: Solve the puzzle provided in the Beginner and Intermediate Start File.   ADVANCED: Solve the Sudoku puzzle from the Wikipedia article (Wikipedia Puzzle Start File).   Welcome to the Death Zone (Source: GIPHY) ... View more

The link to last week’s challenge (challenge #27) is HERE     Use Case:  A company has to process financial data for their visualization tool.  Today this is a manual process in Excel.   Objective:  Build a process in Alteryx that automates the formatting of the daily data feed.   Note: This data comes in daily and is always in the exact same format.     ... View more

Here is a new challenge for this week. The link to the solution for last week’s challenge is HERE. The use case: We received some text data and that includes an embedded line-feed character. The objective is to remove the new line character, convert the date-time string to a date-time formatted field and then do some renaming per the sample output. Good luck, I look forward to your feedback. ... View more

Congratulations on completing Exercise 1!    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