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.
I'm not a big fan of RegEx to start with and I probably attacked this in the wrong way. But in the end, I got the right answer, so there is that.
I started by adding a record count, as I thought initially I was going to have to split the data by date time as I parsed out the info and I wanted a way to ensure I didn't duplicate, then decided that if I waterfalled the selections (by letting those selections that I'd already solved for fall out of the process) it would allow me to narrow down the data regex to a better degree. At the end, I unioned them back together for the final result. I added a validation piece that allowed me to check my results against those results provided as well.