THIS SESSION IS NOW LIVE: WATCH VIDEO BELOW!!!
This challenge is a special Inspire edition and will have rules for completion! Complete the following challenges in order as they are listed. Once you complete the first challenge, you will graduate to the next tier of challenge, until you summit! Use the 'expect equals' to quickly verify you have completed each level. At the end of 20 minutes, we will see who has ascended the most levels
Base Camp: You've already arrived at basecamp - you opened this workflow!
Camp 1: Decrypt the morse code message to a clean readable text. Hint: There is a space between morse code letters and a '/' separating words
Camp 2: In the message from camp 1, parse out the expedition ID and use it to find the 'accident' for that expedition.
Camp 3: Recompile the message in 'accidents' back into morse code. Hint: Make sure there is a space between characters and a '/' between words. Check your answer against the expected output by connecting it to the 'expect equals' tool.
Try entering your message at: https://morsecode.scphillips.com/translator.html
Summit: Post your workflow back to the Community!
... View more
Hi Maveryx,
A solution to last week’s challenge can be found here. This week’s challenge was submitted by Alteryx ACE and Grand Prix champion, Claire McCollough! Thank you, Claire (@clmc9601) , for this exciting challenge submission!
Can you solve the mystery of the unjoined records?
As part of a performance analysis, you have two datasets: one containing the Item Number and Item Cost, and another containing Item Number and Product Type. Your task is to get the Item Number, Item Cost, and Product Type all in the same table.
Although it looks like a simple Join tool would do the trick, for some reason, the rows do not join correctly. You need to determine the extra steps you need to take to make the join work.
Tips:
Modifying the input YXDB files or retyping the data is NOT a valid answer. Your solution should use Alteryx Designer tools and work even if you have hundreds or thousands of items.
All five records should join upon output. For the correct answer, none of the Item Numbers should contain leading or trailing spaces or invisible whitespace.
If you get stuck, feel free to open the hints provided in the Start workflow.
Source:
You can visit https://www.babelstone.co.uk/Unicode/whatisit.html to identify the Unicode IDs for the invisible whitespace characters.
Need a refresher? Review the following lessons in Academy to gear up:
Changing Data Layouts
Multi-Row Formula
Good luck!
Academy Team
... View more
Aggregate Consumer Purchases:
For this week’s exercise we will look at customer purchase behavior to decide if we should offer a “Meal Deal” that would add a side and drink to a purchase of pizza or a burger. The incoming data is larger than usual for these exercises so I have packaged the workflow as an Alteryx Package. The link to the solution for last challenge #7 is HERE.
This week’s Objective:
In order to decide if we should start including a new "Meal Deal" on our menu we want to study the potential impact on recent transactions. Please identify the number and percentage of orders since July 1, 2013 which include the following categories of food: Pizza OR Burger along with a Side and Drink.
Summary of Data:
Point of Sale data includes the ticket level information, and the lookup table categorizes items into higher level food categories.
Hint:
Don't forget to join to the lookup table and filter by date.
As always we look forward to your feedback and suggestions!
UPDATE 01/18/2016:
The solution has been uploaded.
UPDATE 12/28/2016:
The challenge, text and solution have been updated.
... View more
Hi Maveryx,
A solution to last week’s challenge can be found here.
As a part of our Weekly Challenge User Group October Takeover event, we selected an exciting challenge we received from @myastarling, a member of the Milwaukee User Group. Thanks, Mya, for this fantastic contribution!
You have been tasked with creating a table of average temperatures by region and determining the locations of the warmest and coldest monthly and annual temperatures in the US. Luckily, you remember that the National Oceanic and Atmospheric Administration (NOAA) tracks climactic data through weather observing stations in the 50 US states and US territories, and the National Centers for Environmental Information provides access to the data.
In addition to a variety of other climate measurements, NOAA tracks average temperature. You get the OK to report temperatures by weather station. Using a dataset that contains the normal mean daily temperatures between 1981 and 2010, your challenge is to provide the following:
The station with the warmest average annual temperature
The station with the warmest average monthly temperature, and the month it occurs
The station with the coldest average annual temperature
The station with the coldest average monthly temperature, and the month it occurs
A table of all stations and their average temperature by month
Source: https://www.ncei.noaa.gov/pub/data/ccd-data/nrmavg.txt
... 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