Maveryx Academy

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

Last week's challenge can be found HERE!   You have been given some order information that contains a list of orders with SKUs and related quantities. Additionally, you have a data set with the total inventory for each SKU. You have been tasked with figuring out how to consume all of the inventory with the least amount of orders. In other words, you have been asked to fill the largest orders for each SKU in descending order.   Additionally, only complete orders may be fulfilled. For example, if an order calls for 4 units of a SKU, and only 3 are left in inventory, you can't fulfill the order. ... View more

The solution to last week's challenge can be found HERE.   This week we are changing it up a bit and pulling a question that was asked to the Community last week! The issue was that the user had a spatial object that had "holes" inside the object. The challenge was to fill in any holes within the object. The answer to this solution can be solved in very few steps, but the challenge comes in knowing or discovering the right configurations within the tools used to solve the problem. If you would like any hints or to find out how the question was solved, check out the original post which also contains the solution:   https://community.alteryx.com/t5/Advanced-Analytics/Remove-holes-from-a-polygon-object/m-p/48652   ... View more

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

                A solution to last week’s challenge can be found here.    Are you fascinated by the interplay of strategy, skill, and statistics in sports? Does the idea of discovering talent in the realm of cricket thrill you? If you are nodding your head, then gear up!   Challenge Objective: Assemble Your Dream US Cricket Team Your mission—should you choose to accept it—is to identify the crème de la crème of US run scorers in cricket. You will be handed a treasure trove of international cricket match data, and your goal is to sift through the numbers to pinpoint the Top 5 US run scorers who would be the perfect fit for your dream team.   Bonus: Watch an on-demand webinar featuring Shane Watson, Head Coach of the San Francisco Major League Cricket team, the Unicorns, as he talks about how analytics optimizes strategy and performance.   Source: https://www.kaggle.com/datasets/paritosh712/cricket-every-single-t20i-international-innings ... View more