140|ALTERYX – Word Crunch

[Marco]

BYU Student Author: @Marco
Reviewers: @TylerBooth, @Brett_Lowe
Estimated Time to Solve: 25 Minutes

We provide the solution to this challenge using:

• Alteryx
• Go here to perform this challenge in Excel

Need a program? Click here.

Overview
After getting all your work done at The Data Analytics Guys LLC, you find yourself bored and looking for something to do. You’ve been wanting to learn more about Alteryx with matching string to improve your skills, so you look for a list of random words online. While trying to think of something to match the words to, your mind thinks of TechHub.training’s recent launch and so you decide to match the words with the letters in “techhub” in honor of it.

Instructions
Your output should only show the words that are made up of letters in “techhub”. Show the character length of each word and filter out words that are less than 3 characters long. The words must contain the letter “u” in them. The letters can be used more than once. Lastly, sort the data by the highest character length.

Data Files

• Challenge140_Data.yxmd
• Challenge140_Data_Words.xlsx (download this, if the file in Alteryx doesn’t work)

Suggestions and Hints

Use a transpose for the word list. Try using the RegEx tool with tokenize.

Solution

Challenge140_Solution.yxmd
Solution Video: Challenge 140|ALTERYX – Word Crunch

[Benjamin_Lau]

Thanks Marco for the challenge! I learn to use Regex_CountMatches and tokenize for the first time!
Challenge102_Data.yxzp (18.5 KB)

[Millie_K_B]

This was a great challenge! I had to brush up on my Regex knowledge to complete this one.