cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Looking to expand your Alteryx skillset?! Check out the latest set of interactive lessons in Alteryx Academy: Creating Analytic Apps
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #20: List Parsing

Asteroid

First time using the RegExMatch function!

Alteryx Certified Partner

Adding my solution.  interesting twist having phone number at end of address and splitting up.  Thanks

Alteryx Certified Partner

Adding my solution.  interesting twist having phone number at end of address and splitting up.  Thanks

Highlighted
Quasar

Go there in the end. Need to tweak a bit to get all the possibilities. Learned a lot.

Asteroid
 
Alteryx Partner

Wow, that took me way too long, I had to take a peek at some spoiler screenshot to figure it out.

Glad I did it though, feeling more comfortable with the transpose/crosstab gymnastics :D

Asteroid
 
Asteroid

Challenge solved - it was interesting to see how others resolved this, many of which were different from mine. Some good ideas!

Alteryx
Alteryx

I got to a 98% "there" solution pretty quickly, and in the real world would have run with it.  Getting it perfect took some work, re-work and re-re-work.  In the end there are many less tools on the canvass, though I am sure I could reduce by another 25% easily.  It isn't pretty, but it works.

 

Spoiler
Spoiler:

Using lots of multi-row tools, I made the (null) rows around the record start and end consistent in order to mark the start and create groups.  Once I had all of the groups marked, I was able to concatenate by group and proceed to parsing.  Because I didn't know the total variations of phone formats needing to be parsed from address, I ended up using the RegEx parse tool to identify each pattern individually. After that is what just a matter of consolidating the RegEx parsing results into one field and then using RegEx replace in a formula tool to remove the phone numbers from the address field.  


20 Workflow.jpg

 

 

Asteroid

My solution.

Much longer than the solution provided on the in the first post, but anyway working properly :-)