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...
The solution to last week's challenge is HERE.
This week we will be offering our third ever challenge on converting strings to dates. Sometimes these may be simple, but every once in awhile, we come across those source systems that drop things in a format that are better understood by machine than by a human. In this week's challenge, convert the string to a date using the following rules:
1) The Input contains dates formatted as year, month, day where the first character details if the year begins with 19 or 20.
2) It is 19 when the first character is 0 and 20 when the character is 1.
3) The remainder of the date following the 0 or 1 is the remaining year digits followed by month followed by day.
Example: 1040202 should become 2004-02-02.
... View more
Last week's solution can be found HERE!
For this challenge that is taking place on Valentine's Day 2017, build and an app that can find the nearest candy and flower stores near a user-given location. As a result, the application should be able to do the following: 1) Take a map input of a user's location 2) Allow the user to choose between 'florists' and 'confectionaries' 3) Choose if the user wants to find closest distance or drivetime 4) Based on #4, allow the user to input how many minutes or miles are the willing to travel 5) On the output of a map report, allow the user to specify a header 6) Allow the user to specify the directory they want to save the report to
Hint: If the Primary SIC starts with '51' it's a confectionary, if it starts with '59', it's a florist. Be aware that these are Colorado stores only.
For anybody who solves the challenge on or before February 15th, we will be awarded this special badge! If you could not figure out the solution, you can earn the following badge by attending THIS live training, where you can watch how the solution for this challenge was built.
... View more
Last week's solution can be found HERE.
This week's challenge, by its title, sounds like a simple task. However, a quick look at the data will show that it's not going to be just a summarize tool. If you have been meaning to finally learn the RegEx tool, this exercise will be a great first foray with a relatively simple expression. In this exercise, we will take a set of very ugly data, parse it to find hashtags within a text field, find out how many times the hashtag was written, and what users used the hashtag.
If you would like to learn more about our RegEx Tool - check out our help on the tool. If you would like a simpler RegEx overview, check this interactive learning out.
Good luck!
... 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
The link to last week’s challenge (exercise #54) is HERE.
2013 Alteryx Grand Prix Lap 1 of 3:
As the Alteryx User groups start the process of selecting their competitors for the 2017 Alteryx Grand Prix I thought it would be fun to bring back an old Grand Prix as the weekly challenge. Note the workflow is in a vertical orientation. Vertical was the only orientation Alteryx had in 2013. Now, we can toggle between vertical and horizontal configurations by clicking on the white space of the canvas, going to the configuration window, and choosing a layout direction.
Want to have even more fun, go to the about box under the help menu and double click the little Colorado flag for an Easter egg that will render the tools the way they looked in 2013.
Have fun solving and remember the competitors were racing each other and the clock! See how fast you can solve this. OH, and there was NO Imputation tool in 2013...
... View more