Forum Discussion
How to create a column that determines the county from column that has zip codes?
I have a column that says the zip code for each row of order data. I need to create an additional column that says which county each zip code is in.
Hi Anonymous ,
If you want to show the country of each zip code on visual, you can select "map", and then put "zip code" into "location". You can also turn on the "Category labels" to show the zip code on the visual.
If you want to show the country of each zip code in the table, you need to have the data about zip code and country name so that you can reference it.
And I suggest you can try MahyarTF's MahyarTF suggestion to download the data to add a new table which includes the zip code and country name. Then establish a relationship between two tables with "zip code".
Finally, you can reference the "country" on your original table.
Best Regards,
Community Support Team _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
MahyarTFMemorable Member
Hi,
In my point of view, you need to have another table that is included the zip code and country name and then make a relation between this and your table and use the countries' names in your visual. There is plenty of site you could download the data like :
https://data.opendatasoft.com/explore/dataset/geonames-postal-code@public/export/
Appreciate your Kudos and please mark it as a solution if it helps you.
- v-xiaosun-msft
Community Support
Hi Anonymous ,
If you want to show the country of each zip code on visual, you can select "map", and then put "zip code" into "location". You can also turn on the "Category labels" to show the zip code on the visual.
If you want to show the country of each zip code in the table, you need to have the data about zip code and country name so that you can reference it.
And I suggest you can try MahyarTF's MahyarTF suggestion to download the data to add a new table which includes the zip code and country name. Then establish a relationship between two tables with "zip code".
Finally, you can reference the "country" on your original table.
Best Regards,
Community Support Team _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello all,
thank you to the responders, but you are missing that the initial request is for "County" NOT "Country". I have the same question so if anyone has figured this out please respond. Thank You!
