Alteryx Academy

A solution to last week's challenge can be found here.    This week's challenge was submitted by @Maskell_Rascal & @mceleavey - Thanks for your submission!   For this week's challenge, we have provided a list of transactions including the [Client_Number], [Date], & [Finance Amount]. Since not every customer makes a purchase everyday, they only appear on dates that they have made a purchase. We would like to include current customers in the dataset with a "finance amount" of 0 for the missing dates after their first purchase. They should not have entries for dates prior to their first purchase. Assume first purchase dates are the earliest entry in the dataset. ... View more

A solution to last week’s challenge can be found here.   To solve this week’s challenge, use Designer Desktop.   This challenge comes to us from @Pawel_Paleczny  Thank you for your contribution.   The FIFA World Cup is currently taking place in Qatar. Pavel would like to perform analyses on the event.   The first dataset contains information about the stadiums: stadium name, city, capacity, latitude, and longitude. The second dataset contains information about the events: match number, round, dates, location, which teams are playing, and the group or phase.   For this challenge: 1. Assuming that each match will have a full audience, find the top 10 teams that could have the largest audience in the group stage. 2. Find the three cities with the most World Cup matches. ... View more

A solution to last week's challenge can be found here!    This challenge was created for a HackCU hackathon event in which teams were formed and were given 24 consecutive hours and Alteryx Designer to solve the challenge.   In this challenge you must break apart the given [encoded_string] into two character pairs and then build a decoder table, mapping the two-character pairs into ASCII characters to reveal a pig-latin encoded document.   To solve, or not to solve: that is the question.   ... View more

A solution to last week's challenge can be found here.    If you're familiar with the Formula tool in Designer, you know that there aren't many things you can't do with it. But just because you can do something doesn't mean that you should. There are some tasks that can get a little repetitive when you have to do them over and over again. In those instances it can be more efficient to think about ways to make the process a little more dynamic. This also serves you well as you begin automating processes because it can keep workflows from breaking when datasets change.   For this week's challenge, we want to perform a simple calculation: divide each month's Tax value by its Cost value to find the Percentage. Since there are almost always multiple ways to accomplish the same task, go for a double dip and find two solutions to arrive at the final output. ... View more

A solution to last week's challenge can be found here!    This week's challenge comes to us from @BuQu - thanks so much for the contribution!    Using the provided input, count the number of times each word appears in the text. Then, sort the words in descending order and show the percentage of that word's use against the total word count.   Hint: Make sure there are no truncated fields in your input.   Bonus: Use the download tool to get text directly from the website instead of using the text file.         ... View more