Alteryx Academy

The solution to last week's challenge can be found HERE.   This week, let's take a break from all of those business uses cases and have some fun! In this challenge, create a field that indicates whether two values in each row are anagrams for each other. An anagram is a word formed by re-arranging the letters of another word. In our case, all anagrams are one word and are not split to multiple. No letter can be used more than once, and all letters must be used.   ... View more

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

A solution to last week’s challenge can be found here.    Have you ever wondered if all the countries in the world celebrate the New Year? In many countries, New Year's Eve is celebrated at evening parties, where many people dance, eat, drink, and watch or light fireworks. Some countries celebrate New Year on a different day/month, and some don't celebrate the holiday.    The following dataset provides information about holidays around the world.    Based on the information provided: - Which countries have 2 days of holiday for New Year? - What are the countries that don't have New Year's Day as a Holiday?   Source: https://www.kaggle.com/arthurio/world-holidays-2019 ... 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