Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Unusual zip code ranges, singular, rest of state or entire state

jokeffer
7 - Meteor

I have a .xlsx file with state and first 3 zip codes, but also has "rest of state", "entire state", "entire area", "International" and an assignment column. When it does have first 3 zip code, the codes can be listed as 350-352, 362 etc. How can this be made to represent every 5 digit zip code for the state and keep the assignment value?
File attached. 
Appreciate any an all assistance!
Jo

6 REPLIES 6
jokeffer
7 - Meteor

Attached .xlsx of all states and zip codes needed to match to previous file.

Qiu
20 - Arcturus
20 - Arcturus

@jokeffer 
I think I deserve an accepted mark if this what you want.
1023-jokeffer.PNG

Qiu
20 - Arcturus
20 - Arcturus

@jokeffer 
And if you would agree, I would like to submit this one as an idea for Weekly Challenge.

jokeffer
7 - Meteor

You are truly an Alteryx Genius!

And I still have a lot to learn!!!!
Thank you Qiu!!!!

Qiu
20 - Arcturus
20 - Arcturus

@jokeffer 
Thank you for the mark.

I will try to submit this one as a weekly challenge with our names.

jokeffer
7 - Meteor

Thank you Qiu!

Labels