Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Here's my solution... I was hoping to use Regex a lot more but this got the job done quickly and was more in my wheelhouse. Very interested to look through other solutions. Thanks!
Edit: I see after perusing some of the other submitted solutions, that you can use the formula tool to add the clue column. I'll need to give that a try. Mine was not quite a complete solution. 😀