140|ALTERYX – Word Crunch

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

We provide the solution to this challenge using:

Need a program? Click here.

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.

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

Suggestions and Hints

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


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

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