community
cancel
Showing results for 
Search instead for 
Did you mean: 
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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #20: List Parsing

Asteroid

Hi! Here my solution :)

Highlighted
Alteryx Partner

My solution : 

Comet

This took some time to tease out all the iterations of how data is presented.  My workflow has a discrepancy for record #1252.  After reviewing the data and looking at the presentation of the fax number for this company, it looks like the number at the end of the address is actually the phone number and not part of the address.  I could have added to my last formula tool to remove this result and put it back on the address, but my results are correct as is and I am leaving the discrepancy.  If I was creating this for production, I would have completed the data cleanse and made the phone/fax numbers in standard format.

Spoiler
workflow 20.GIF

 

Asteroid

That was a more challenging challenge for me

Asteroid

My Solution:

Spoiler
Capture.PNG
Quasar

Here is my solution!

Fireball

Didn't quite get the address parsing perfect, but got really close... Regex-a-palooza!

 

Spoiler
challenge_20_workflow.PNG
Alteryx Certified Partner

I think the big learning on this one is the Phone number parsing!

Atom

Found this one challenging! My take on it ...