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

logdog0411
8 - Asteroid
Spoiler
logdog0411_0-1674665742646.png

 

I had some fun just cutting and pasting street names and abbreviations from a web search, then cleaning them in the blue tool container. Not the most artful solution, but it works. 

kristiadiuisan
8 - Asteroid
Spoiler
Alteryx_challenge_54_KU.png
Flo_P
8 - Asteroid
Spoiler
Flo_P_0-1675436927729.png

 

psk009
8 - Asteroid

#54 Solution: It's not that simple (went back and solved after I checked the solution), Tools used - RegEx, Text To Column, Select and Data Cleansing

 

Spoiler
psk009_0-1675443084539.png

 

Kiwi_Li
8 - Asteroid

Regex is always confusing, but it's done!

 

Spoiler
Kiwi_Li_0-1676411494196.png

 

gaoa
11 - Bolide

My solution:

 

Spoiler
gaoa_0-1676742932572.png
benjimoser
9 - Comet

My Solution

Spoiler
benjimoser_0-1676980394657.png

 

akorte1
8 - Asteroid

Done

Lakshya_05
8 - Asteroid
Spoiler
 
Ed2000
8 - Asteroid
Spoiler
Ed2000_0-1677073234199.png