Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
I have a shapefile with Mediterranean countries, and an attribute table such as the one below:
In an excel spreadsheet, I have population data for all of these countries, which I'd like to assign.
Is there a way I can export my excel data so that population of Italy is assigned directly to Italy in the attribute table for example?
You'd need a field in both the layer and the attribute table which contains the same values, e.g. the shortcuts for the countries. Then go to layer - add layer - add virtual layer and give the fields with the country-codes as unique ID.
I don't have right to comments, so I will ask here and edit/delete accordingly.
Do you have a dictionary which links Country in excel (which are in short codes) to country_name in attribute table (which are full name)?
