Tuesday 28 May 2019

Getting duplicate values when joining .csv spreadsheet to .shp map layer using QGIS?



I need to join .csv/spreadsheet data to the .shp map layer. The join itself isn't a problem with same join & target values (building) but some data goes missing because of duplicate values.


For example, if the map data is buildings and spreadsheet contains information about workers: info from workers from the same building gets missed because the join is done by the value of the building to combine spreadsheet to the building map layer.


How do I present all the information about workers in the map even if the info is from the same building?


The join isn't possible with any other value.


For example


enter image description here




No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...