Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #20: List Parsing

Highlighted
8 - Asteroid

Hi! Here my solution :)

Highlighted
Alteryx Partner

My solution : 

Highlighted
13 - Pulsar

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

 

Highlighted
8 - Asteroid

That was a more challenging challenge for me

Highlighted
8 - Asteroid

My Solution:

Highlighted
8 - Asteroid
Spoiler
Capture.PNG
Highlighted
13 - Pulsar

Here is my solution!

Highlighted
11 - Bolide

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

 

Spoiler
challenge_20_workflow.PNG
Highlighted
Alteryx Partner

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

Highlighted
5 - Atom

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