Alteryx Academy

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.   Are you wondering which artists produced the top songs? Do you want some insights? This challenge is for you.   The following dataset contains information about the top 500 songs. Using the dataset, find the top 50 artists with the most albums and the highest average rating. Include the following columns in your list :   - Artist(s) - Number of albums (Descending) - Average rating based on all albums (Descending) - Album title(s) - Average number of reviews based on all albums (Descending) - Genre(s) - Year the first album was released - Year the last album was released Note: If in your solution you have null records for the Release Year, do not include them.   This challenge was updated to propose 2 start files and 2 solutions.   ... 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 has been posted HERE.   A university analyst has been asked to help with course and classroom resource planning. The university sends course times in military time format. The university analyst wants the fields Military Begin Time and Military End Time to display in standard, 12-hour increments. So, if a course ends at 16:30, he would like it to show as 4:30. He also wants to know what the elapsed time is between the two fields mentioned above. How long is each course? Minutes will be the time unit measured.   ... 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