Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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.

SUBMIT YOUR IDEA

Challenge #54: Data Prep Address Parsing

cmoussa
8 - Asteroid

👍

DylanBell
10 - Fireball

My solution:


Bulien
martinson
11 - Bolide

I used a list of common street suffixes to help me 

Cheers,
martinson

LinkedIN

Bulien
Minanashat
8 - Asteroid

My Solution 

myastarling
11 - Bolide

Here's my solution. I identified suffixes using a table of USPS-approved values so the logic could be applied to other addresses, which added several tools to this. 

ntakeda
12 - Quasar
Spoiler
2025-02-27_14h56_58.png

Only 3 tools

s_wright
8 - Asteroid

Solved challenge_54 attached.

JBevan89
8 - Asteroid

My Solution attached.  There must be so many ways to do this, but ultimately know Regex is needed😫

Dominic_Brady
8 - Asteroid

My solution

TGreen
8 - Asteroid

Solved with RegEx only.