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.
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

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 #245: Zip It Real Good

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found hereSource: https://en.wikipedia.org/wiki/ZIP_Code#Scope_and_international_mailSource: https://en.wikipedia.org/wiki/ZIP_Code#Scope_and_international_mail

 

This week's challenge was submitted by @Qiu  - Thanks for your contribution!

 

Zip codes were created in 1963 to help the United States Postal Service process mail based on the parcel’s intended destination. The codes consist of 5 digits; the first 3 of which determine the sorting center that receives the parcel. While the zip codes help to organize mail delivery, they are not necessarily aligned to geographic boundaries such as state or cities.

 

For this week's challenge, we have 2 datasets: The first lists some classifications (Assignments) which are intended for specific areas. These assignments can be consistent for an entire state, or only apply to specific zip codes within a state (or territory). The other dataset is a listing of all 42,004 zip codes for the United States and its territories. Your job is to produce the correct “assignment” for each of 42,0004 the zip codes.

dsmdavid
11 - Bolide

 

Spoiler
dsmdavid_0-1607351492444.png

 

 

AkimasaKajitani
14 - Magnetar

My solution.

 

Spoiler
AkimasaKajitani_0-1607352703733.png

 

DeanWest
8 - Asteroid

Pretty nice challenge to start off the week. 😀

Spoiler
challenge_245_solution-DeanWest-snippet.png

 

RolandSchubert
15 - Aurora
15 - Aurora

My solution.

 

Spoiler
245.png
PaulFound
11 - Bolide
Spoiler
PaulFound_0-1607356577873.png
PaulFound_1-1607356591763.png

 

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 245 is done!

 

Spoiler
Jonathan-Sherman_0-1607357084544.png

 


 

 

JennyMartin
9 - Comet
Spoiler
AWC245.PNG

Love a logical challenge! Video solution here: https://www.youtube.com/watch?v=ooUdS2GhpZY&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=49

Find the Challenge here:https://community.alteryx.com/t5/Weekly-Challenge/Challenge-245-Zip-It-Real-Good/td-p/676980
Kenda
15 - Aurora
15 - Aurora
Spoiler
Kenda_0-1607358266063.png

 

phottovy
11 - Bolide

Not super streamlined but it works:

 

Spoiler
245.PNG