Using Regex to find key information from a free input text field

Preppin data week 5 spoilers ahead. Complete the challenge (you don’t need Regex) before you read! On Tuesday, we learnt what Regex is and how we can use this in Tableau, Tableau Prep and Alteryx. So when I saw that Regex could be used to help solve this week’s Preppin data challenge, I saw this as a great chance to practice using Regex and my Tableau Prep skills at the same time.

Small tips to reduce changes in Tableau Prep

While completing this week’s Preppin data challenge, I noticed a couple of small things that would reduce the number of changes listed in Tableau prep. I feel this can be useful as I find it is less daunting to look at what is happening in a tool when it has 10 or...