Learn

A solution to last week's challenge can be found here.   This challenge was submitted by Alteryx ACE Esther Bezborodko @estherb47 . Thank you, Esther!  Use Designer Desktop or Designer Cloud, Trifacta Classic to solve this week's challenge.     This challenge is a variation on the New York Times Spelling Bee puzzle. For this challenge, we will use the same list of words we used in Challenge #356.   Although Merriam-Webster’s Dictionary defines a pangram as “a short sentence containing all 26 letters of the English alphabet,” for the purposes of the New York Times Spelling Bee, their  Glossary defines a pangram as a word that uses seven unique letters and is worth seven extra points. We will use this definition as a guide for our challenge.   Your goal here is to find, within the list of words, the pangram with the highest point value and the individual letters that comprise that word. For that, you need to do the following:    Find all the words within the list with seven unique letters. It does not matter if the word uses a unique letter more than once; this letter will still be unique within the word. For example:    Alteryx has seven unique letters.    Statistically also has seven unique letters.    Once you find the words with seven unique letters, determine their point value. Each letter is worth one point. For a pangram, the point value is calculated by adding 7 to the value for the length of the word. For example, in ALTERYX, the total value is 14 points (7 [the word length] + 7 [pangram extra points]). The result should look like this:   ... View more

A solution to last week’s challenge can be found here.   Do you check the weather before planning a trip to a foreign country?    The following dataset contains information about the temperature of various locations in Ireland. Your job is to find the following the average (rounded up), the minimum, and the maximum temperature by "Station" in the Spring, Summer, and Fall. Use only the temperature recorded at 12:00.   Note: Use the following dates to determine the seasons: - Spring March 19 - Summer June 20 - Fall September 22   Thank you for your comments, this challenge has been updated. ... View more

A solution to last week’s challenge can be found here.   To solve this week’s challenge, use Designer Desktop. Challenge Created by: @PhilipMannering      Description: Based on the data provided, your task this week is to find all possible words in the Spelling Bee puzzle sorted by length (descending). The Spelling Bee puzzle is a grid of seven letters. The rules for valid words are: 1. You must only use letters found in the grid. 2. You must use the center letter at least once in each word. 3. Words must contain at least four letters. 4. Letters can be used more than once. The first input contains the grid of letters. Hint: You will (quite literally) require ALTERYX to find the perfect pangram.     Designer Version Used to Create: 2020.3 ... 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.    This challenge comes to us from @randall_king. Thank you for your contribution, Randy! Use Designer Desktop or Designer Cloud, Trifacta Classic to solve this week's challenge.   Your Human Resources department received a CSV file with the names of all new employees hired for all stores in the last month. They want to create these new employees’ email addresses. The company uses the initials from an employee’s first name and last name to create these emails. For example, Ana Muniz would be assigned AM@organizationname.com. If more than one person shares the same initials, add a number after the second initial. For example, Alan Murphy would be assigned AM1@organizationname.com.   For this challenge, you can provide an intermediate or advanced solution.   For the intermediate solution, use the CSV file to generate the emails using the fixed company domain, organizationname.com. Your output file should contain the following columns:   First Name Last Name Email Address   For the advanced solution, create an app where users can input a specific domain name through an interface similar to the one in the following image , and provide the same output as the intermediate solution.   ... View more