We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.
alteryx Community

# Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

## Challenge #54: Data Prep Address Parsing

7 - Meteor

This was a fun one! I initially completed this challenge without using RegEx. However, upon seeing that it was used in many solutions posted here, I learned how to use it and completed the challenge again.

Here are my two solutions:

Spoiler

ACE Emeritus

i tad harder than "beginner" level... i went with Python usaddress library and then CASS/regex Tools for the pure Alteryx approach. Even the python method took me throughout yesterday to track down how to manipulate the output.

Spoiler
``````#################################
from ayx import Alteryx
import pandas as pd

try:
return text[0][variable]
except KeyError as e:
return None

#SnakingMyWayThruChallenges

10 - Fireball

My solution

Spoiler
8 - Asteroid

Here is my solution.

Spoiler
7 - Meteor

Here is my solution! In browsing through others', looks similar to CKP's recent one

Spoiler

8 - Asteroid

My solution.

7 - Meteor

My solution would not work if there were hundreds of records but there were only 8 displayed, so I basically kept adding formulas to get the data to look how it looks in the output goal. I'm still a beginner and even though this challenge says "beginner", I saw the posted solutions and became overwhelmed so I did it my own way. Again, not the most practical way at all, but it gave me some good practice with formulas.

9 - Comet

I'm really getting into RegEx. Or maybe I'm becoming a masochist...

8 - Asteroid
Spoiler

In attach my solution

8 - Asteroid

Solved! Getting the cities took me a while

Spoiler