Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #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
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1607352703733.png

 

DeanWest
9 - Comet

Pretty nice challenge to start off the week. 😀

Spoiler
challenge_245_solution-DeanWest-snippet.png

 

RolandSchubert
16 - Nebula
16 - Nebula

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

Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1607358266063.png

 

phottovy
13 - Pulsar
13 - Pulsar

Not super streamlined but it works:

 

Spoiler
245.PNG