We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #54: Data Prep Address Parsing

Marcel_Gavrila
8 - Asteroid

Here's my solution! I know that I did not rename the "Address Text" to "City", but I wanted to use only one tool.

Spoiler
Capture.JPG
Lila
6 - Meteoroid
 
mbogusz
9 - Comet
Spoiler
2019-07-21 13_36_53-Greenshot.png
mbogusz
9 - Comet

@Marcel_GavrilaUsing one formula tool with multiple formulas that is quite a feat.  Nice.

MartinStraech
8 - Asteroid

Interesting challenge. Reused the text input provided in the solution, but otherwise most of the steps done through the formula tool instead of regex.

 

Spoiler
SolutionClipping.PNG
fmeo
8 - Asteroid
Spoiler
54.PNG
Spoiler
 
Spoiler
 
sara-hamdoun
7 - Meteor
Spoiler
SPOILER

Challenge 54.JPG

MikeHinz
8 - Asteroid
 
arein0
8 - Asteroid
Spoiler
54.png
rslopez2
8 - Asteroid

Used Delimiter text to columns to isolate string after Street references

Used REGEX to extract state

Then used count and substring formulas using the above derived data to extract city names

 

Spoiler
RL_challenge_54_Solution.png