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.
- 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.