ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
community Alteryx IO MyAlteryx
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
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

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 Alumni (Retired)
‎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