Learning Resources

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

Here is a new challenge for this week, it is a continuation from last week’s warehouse distribution challenge. If you did not complete last week’s challegne don’t worry, you will not need any output from part one to complete this part.  The link to the solution for last week’s challenge is HERE. I posted two solutions for last week’s challenge. The first is a solution without a macro and is in my opinion a more straight forward approach to solving the problem. I included the second macro approach because it is an excellent example of how to utilize an iterative macro.   The use case:   Based on data from last week’s warehouse distribution challenge, we want to calculate the total shipped miles per item. The products are available from 3 different warehouses, lat/lon data is provide for each warehouse and each store location.   Your goal is to find the total distance travelled as straight line miles for each item based on it being shipped from the closest warehouse.   Good luck, I hope you are having fun with these challenge and expanding your knowledge of Alteryx. Thanks to all that have provided feedback. ... 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 @atcodedog05 Thank you for your contribution!   Are you a fan of the sitcom The Office and the character Michael? This week is Part 2 of the "Goodbye, Michael" challenge. Part 1 can be found here.    The dataset contains information about the seasons, episodes, scenes, and lines of the series. In the episode “Michael’s Last Dundies,” there is a goodbye song that is sung to Michael by his employees. Find and extract the 18 lines of the song from the dataset and who sings each line. In the dataset, the song starts after Michael says, "Oh my God, something's happening," and ends with him saying, "Yeah, okay. Well this is gonna hurt like a mother."   Data Source: www.kaggle.com/datasets/nasirkhalid24/the-office-us-complete-dialoguetranscript   ... 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

  Hi Maveryx,   A solution to last week’s challenge can be found here.   This challenge was submitted by Ippei Nakagawa, one of our most creative contributors to challenges. Thanks, @gawa , for your invaluable contributions, and again it was a pleasure meeting you in person during Inspire2024!   Though perfect people may be a myth, perfect numbers are real! A perfect number is a positive integer that is equal to the sum of its divisors (excluding itself).   Your challenge is to examine the provided dataset, which is a list of integers ranging from 1 to 10,000, and determine the perfect numbers hidden within. For example, the smallest perfect number is 6, which is the sum of its divisors: 1, 2, and 3.   Need a refresher? Review this lesson in Academy to gear up: Summarizing Data   Good luck!   ... View more