Alteryx Academy

A solution to last week's challenge can be found here!    Using the data provided in the start file, create an ordered list of the provided unofficial holidays.       GIPHY  Get ready for Answer the Phone like Buddy the Elf Day on December 18!  ... View more

A solution to last week's challenge can be found here!   Nothing makes you feel quite as nostalgic as hearing a song you haven't heard in a while.  That's probably why Billboard magazine has been publishing their "Hot 100" list since 1958. If you aren't familiar, the "Hot 100" list ranks the top 100 singles in the US each year. It can be pretty fun to read through, but let's take a look at who dominated the decades.   This challenge's dataset includes rankings from 1965-2015. Determine which artist(s) created the most top 100 hits in each decade. Then, try the same but with top 10 rankings.   ... 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.    Using the values in the attached file "womens_world_cup_data.txt", determine which team won the most matches.      Go Team USA!   ... View more

Hello, Community Members!   A solution to last week’s challenge can be found here.   This challenge was submitted by Patrick Digan (@patrick_digan). Thank you, Patrick, for yet another excellent contribution!   You are provided with a folder (Cryptocurrency_Datasets.zip) of 24 monthly files (formatted as InputDataByMonthYYYYMM) containing data related to bitcoin mining and its environmental impact—specifically carbon emissions (CO2) and energy consumption (kWh).   Each file includes a Date field (YYYYMMDD) along with four concatenated columns in the DownloadData field: 24hr_kWh, 24hr_kgCO2, Output_kWh, and Output_kgCO2.   For each of the 24 months, calculate the average for the 24-hour power consumption (24hr_kWh column) and CO2 emissions (24hr_kgCO2 column). Using these averages, find the median for both fields.   Hint: If you use Regex, your numbers may vary slightly. Alternatively, use the Parse JSON tool for this type of data in a name/value pair format, similar to JavaScript.   Need a refresher? Review the following lessons in Academy to gear up: Changing Data Layouts Summarizing Data   Happy solving!   The Academy Team ... View more