28

I have joined corresponding Local Enterprise Partnerships table data into a polygon shapefile containing UK Local Authorities.

enter image description here

How do I Dissolve or Merge the the Local Authorities polygons by LEP_NAME as shown in the screenshot?

Ideally, I would like to retain the Local Authority attributes with the resultant merged polygons. I have zero scripting knowledge so am looking for a tool based solution.

enter image description here

Additional Note: When attempting to use the dissolve tool the LEP_NAME field is not available as shown above. The LEP attribute data was created in Excel, saved as CSV format and joined to the Local Authority polygon shapefile. There are duplicate IDENTIFI0 fields as shown in the other screenshot.

4 Answers 4

30

use vector ->geoprocessing tools --> dissolve:

select shapefile and field (LEP_NAME in your case), choose name for new shapefile and you are done enter image description here

0
7

I had the same issue. I solved it by saving the post-join shape file down and then dissolving after that. Make sure you have the correct vector layer selected in the dissolve prompt to get your new fields.

1

When one creates a join and links an existing shapefile attribute table with another table, do export the two joined table as a new shapefile and load it again into QGIS. The joined table's fields will then be accessible to various QGIS tools, e.g., dissolve.

0
0

I found that fields do not appears in the drop-down menu when the field "type" is float.

It varies according to the software used, but copying the values to a text field may usually work.

Not the answer you're looking for? Browse other questions tagged or ask your own question.