community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

EdwinYakop
7 - Meteor
‎10-17-2019 08:09 PM

My Solution

challenge_54_start_file Edwin.yxmd
Reply
0 Likes
myouree
8 - Asteroid
‎10-17-2019 09:53 PM

My solution

challenge_54_my_solution.yxmd
Reply
0 Likes
sgrabish1
8 - Asteroid
‎10-19-2019 06:02 AM

Thanks for practice exercise! 

challenge_54_sjg.yxmd
Reply
0 Likes
AbbieRoss-Carter
8 - Asteroid
‎10-23-2019 02:50 AM
 
Challenge 54 Solution - Abbie Ross-Carter.yxmd
Reply
0 Likes
ArnavS
Alteryx
Alteryx
‎10-28-2019 10:07 AM
 
challenge_54_start_file.yxmd
Reply
0 Likes
sarahjohnson
8 - Asteroid
‎10-30-2019 09:14 AM
Spoiler
sarahjohnson_0-1572452075591.png
Challenge #54 (sarahjohnson 10-30-19).yxmd
Reply
0 Likes
rmforcreamlisa
7 - Meteor
‎11-03-2019 02:48 PM

Had a hard time bringing one of the Dallas Texas cities and states through the workflow until I got rid of the . in St. 

challenge_54_LisaSolution.yxmd
Reply
0 Likes
apabonok
8 - Asteroid
‎11-09-2019 03:43 PM

Hi. This is my solution. Tools:

-RecordID

-Text to Column

-Formula

-Summarize

-RegEx

challenge_54_my_solution.yxmd
Reply
0 Likes
KaneG
Alteryx Alumni (Retired)
‎11-10-2019 06:15 PM

Many different methods for this. I went with an external lookup table so that way it can be updated easily.

 

Spoiler
Challenge54.png
challenge_54_Completed - KG.yxmd
Reply
0 Likes
RRS
7 - Meteor
‎11-11-2019 12:09 PM

My Solution

challenge_54_Solution_RRS.yxmd
Reply
0 Likes
curated machine learning resources