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 started this and found it hard to extract the city, after looking at the solution I used the pipe idea however have kept my first attempt in there for the other fields.
I feel like I brute forced this one with calculations, there is probably a better way to do this to ensure that it catches and filters out the street address.