alteryx Community

Weekly Challenge

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

8 - Asteroid

I used this challenge to get to grips with how to use Google's Geocoding API to download address information. Great practice and a shoutout to @mceleavey whose step-by-step guide is perfect.

Spoiler
8 - Asteroid

Thanks for the challenge! Here is my solution:

7 - Meteor

Spoiler

7 - Meteor

Spoiler

8 - Asteroid

Number 13

Had to use words like St, Street, Ave etc to get the city name

Spoiler

17 - Castor

Hi,

Sharing my solution.

I saw that there are much more efficient ways of doing this but I will stay with my solution.

Spoiler
8 - Asteroid

My solution, from a while ago

8 - Asteroid

Loved this challenge! I don't know how to use Regex formulas, so I used "normal" formulas.

Spoiler

I used 4 formulas:

ZIP Code:

ELSE Null()
ENDIF

State
IF IsNull([ZIP Code])
ENDIF

City (Part 1)
IF IsNull([ZIP Code]) THEN
ELSE
ENDIF

City (Part 2)
IF StartsWith([City], "Street ")
THEN TrimLeft([City],"Street ")
ELSEIF
StartsWith([City], "St ")
THEN TrimLeft([City],"St ")
ELSEIF
StartsWith([City], "Ave ")
THEN TrimLeft([City],"Ave ")
ELSEIF
StartsWith([City], "Avenue ")
THEN TrimLeft([City],"Avenue ")
ELSE
[City]
ENDIF

11 - Bolide
Spoiler

8 - Asteroid

🙂