Dive deeper into solving problems with Alteryx, explore new frontiers in your analytics journey, and push yourself to prove and improve your skills with our Certification Program.
Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.
Also available in...
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. 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
A solution to last week's Challenge can be found here!
A big thanks to those of you that joined us last week at Inspire for the Weekly Challenge session! It was so much fun solving with you all!
This week, we're identifying the most popular baby names that were registered between the years of 1880 and 2017. Given the provided dataset, determine the most popular names for Males and Females for each available year. The column "Field_1" contains three concatenated values: the name, the associated gender (Male or Female) and the number of occurrences that the name appeared in birth records. The column "FileName" contains the name of the file in which the record is found; the data was read in from a zip file that contained text files for each year (1880-2017) of records.
... View more
A solution to last week’s challenge can be found here.
To solve this week’s challenge, use Designer Desktop or Designer Cloud Trifacta Classic.
If you are currently selling your home, you may not be happy to learn that capital gains (profit from the sale of the home) are taxable in the United States. One way to reduce the amount of capital gains taxes you pay is to use deductions.
For this challenge, we will use two possible deductions, the Exclusion of Gain (you may qualify to exclude up to $250,000 of the capital gain from your income as a single filer, or up to $500,000 of that gain if you file a joint return with your spouse); and Capital Improvements (when home sale profits exceed the exclusion of gain threshold, consider deducting any capital improvements you made to the home while you owned it).
Your challenge is to answer two questions:
Identify which home sellers will have to pay taxes on the profit made from the sale of their home.
Determine how much those sellers have to pay.
Use the information below to calculate and determine who should pay taxes.
Source: https://www.homelight.com/blog/tax-write-offs-for-sellers/#:~:text=Page%209%20of%20IRS%20Publication,retaining%20wall%20or%20swimming%20pool
DISCLAIMER: This challenge is meant for educational purposes only and is not intended to be construed as financial, tax, or legal advice.
... View more
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