[GIS] Combining rows in an attribute table based on field

arcgis-10.2arcgis-desktoparcmapdissolve

I am using ArcMap 10.2.2 on a Windows 7 PC.

I have shapefile range data for multiple species (multiple species in one layer), and this range data is accompanied by information relevant to the species.

Some of the species I am working with have discontiguous geographic ranges. If species X has three disconnected places it lives, I have three different rows in my attribute table, with lots of redundant data (i.e. there are three rows with identical information EXCEPT the information that relates to the polygon size). Because of this, I have about 3,300 rows for ~250 species.

I would like ArcMap to combine rows based on the species, but I can't seem to figure out how to do this properly.

I've tried dissolving based on the species name field (with multipart features), but when I do this, I just get a new layer with nothing in it.

Any suggestions?

I've tried all the things suggested in How to combine rows in attribute table using ArcGIS for Desktop? but none seem to be working.

ETA: Posted these in a comment, but here are some relevant screenshots:

enter image description here

enter image description here

My intended output would be for all of the highlighted rows in the first screenshot to become a single row. And I would like that done for all ~250 species.

What I'm getting when I use dissolve:

enter image description here

Best Answer

I note in your second image from the field names that you have a Join between a csv and a shapefile, and the field you are attempting to Dissolve on is from the csv. While I can't find it documented at the moment, I believe this won't work. You first need to export your joined data to a new shapefile/feature class and then run the Dissolve on that.

And as mentioned in the comments by Aaron, you always want to make sure you have nothing selected (or only the subset you want) when running a GP tool, as most honor selections and will only run on selected features.

Related Question