Dive deeper into solving problems with Alteryx, explore new frontiers in your analytics journey, and push yourself to prove and improve your skills with...
The Alteryx education program providing software licenses, teaching tools, and learning pathways to empower learners to question, understand and solve...
Need to level-up your knowledge but don’t have time for a long read? Tune in to our podcasts to cover analytics culture, data science, and everything in...
Hi Maveryx,
A solution to last week’s challenge can be found here.
Ellen Wiegand, a Senior Sales Engineer at Alteryx, brought us this brilliant challenge idea. We are truly grateful for your contribution, Ellen!
Considering the importance of renewable energy and to celebrate Earth Day, let's work on a challenge regarding sustainable energy! We have a dataset that provides detailed information about wind towers in the United States and its territories. The text input file contains the latitude and longitude coordinates for Alteryx headquarters in Irvine, California.
Looking only at wind towers with an Attribute Confidence of 3 and Projects with more than one wind tower, complete the following tasks. (Note: The Column Descriptors tool container in the workflow file contains the definitions of the values in the input dataset.)
What is the name of the project closest to the Irvine office (CA)?
How far away from the office is it?
Hint: The provided dataset is a flat file. To facilitate the data extraction, use the JSON Parse tool in the Developer tab of Designer.
Need a refresher? Review these lessons in Academy to gear up:
Parsing JSON
Creating Spatial Objects
Changing Data Layouts
Sources:
https://evwhs.digitalglobe.com
http://www.google.com/earth/download/ge/
http://datagateway.nrcs.usda.gov/
Good luck!
... View more
The link to the solution for last challenge #12 is HERE.
For this challenge let’s look at creating a multi-level hierarchy from employee-manager data. As always there are several ways to do this challenge, I have designated it as an advanced challenge because some of the more complex functions like RegEx can be used, but it is not absolutely necessary.
The use case:
We have HTML data that is in a single field, the HTML contains an HTML Table.
The input contains a series of name/value pairs within the description field. The description field has a HTML table that contains 14 name/value contained within <td> tags. Each pairing can be found on a different row (designated by the <tr> tag).
The objective is to produce a table containing the 14 name/value pairs.
Good luck, I look forward to your feedback.
Update: As of 9/20/19, the start and solution files were updated. Your solution may not match those posted by Community members prior to this date.
... View more
The link to last week’s challenge is HERE.
Wow, exercise #51 already. Can’t believe it has been nearly a year!
For this week I would like to investigate some of the geospatial tools available in Alteryx The spatial tools will allow you to calculate distances, create trade areas, find intersection of spatial objects, calculate sizes, etc.. Even if you don’t have the spatial data from Alteryx (the spatial data provides supporting data packages for geocoding, address standardization and calculations using the road network), most of the tools will still perform as long as you have the spatial references or objects already available in your input data.
Use Case: For regulatory purposes we have been asked to identify the all the counties within a 15-mile radius of each of our stores as well as identifying the percent of the county’s area that is overlapped (Coverage).
Objective:
Part 1) Calculate the percent overlap by individual store
Part 2) Calculate the percent of overlap by county for the entire store network
... 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