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
Solved! Go to Solution.
@jokeffer
I think I deserve an accepted mark if this what you want.
@jokeffer
And if you would agree, I would like to submit this one as an idea for Weekly Challenge.
You are truly an Alteryx Genius!
And I still have a lot to learn!!!!
Thank you Qiu!!!!
@jokeffer
Thank you for the mark.
I will try to submit this one as a weekly challenge with our names.
Thank you Qiu!