Forum Discussion
Zip code (geography type) no longer provides Admin Division 2 (County/district/other)
As title suggests, I was previously able to extract county from zip code (as geography data type), using Admin Division 2. Starting August 28th, I was no longer able to extract this same information from zip codes. Only City, Description & Name are available for extraction using the geography data type. These counties do, in fact, exist. Office version has been kept updated.
See image below.
For context, these zip codes exist in Texas. Some cities have multiple counties so city is not a viable geography data type.
Please advise!
7 Replies
- Hello Team, Can someone suggest me some good materials for Data Tech Profiling I have started a Data Engineer, And SQL is very complex i fell Please suggest some materials.
You may extract first city and from it county. Or by formula to exclude intermediate step
- I'm experiencing the same issue and while I did notice that the method you've described here was a workaround, I'm also now experiencing new, different issues with the geography data as well. Specifically, certain accurate zip codes (e.g., 72206, 72207 in Little Rock, and 63129 in Saint Louis) are unable to populate the associated 'city' column. It just appears with a #FIELD! value. I am able to accurately populate the 'Name' and 'Description' columns from the zip code, but only the 'City' column appears to be able to generate the Admin 1 and Admin 2 columns. This wasn't occurring as of last month, to my knowledge. I'm just curious if you have encountered anything similar to this or may have any ideas.
Unfortunately I have no idea why so. You may Send a Frown to Microsoft. On ribbon Help->Feedback->Report a problem. Not sure it'll be fixed, at least Microsoft monitors such feedback.
Excel discontinued Wolfram data types in June. While I cannot locate a MS article that specifically says Admin Division 2 was dropped (There's only the basic end of support notice at: Excel Data Types with Wolfram End of Support FAQ - Microsoft Support), I did some digging and found it listed on the Wolfram/Excel page here:
Wolfram and Microsoft Excel Data Integration
Admin Division 2 is missing in my Excel, too.
