How to dissolve features and retain fields/values

enterprisemaps-gwest

I have a feature class with 3 point features, I would like to dissolve these so that my 3 features maintain all fields and values in one feature.

 

I would like one feature that has SRAddress, SRNumber, Type, E-WasteType1, Count1, E-WasteType2, Count2, E-WasteType3, Count3

 

 

 

 

 

 

DarrenWiens2

There's probably a much simpler way to get at this (i.e. a time-saving tool or more efficient use of dictionary, etc.), but here's how you can dump the list of values into a new field ("ItemList"), then dissolve. Note that you'll have to change the feature class name, "Electronic" field name (I was using a shapefile, so couldn't fit long name), and add a text field called "ItemList".

>>> valueList = [] # empty list
... with arcpy.da.SearchCursor("SR_Data",["SRAddress","SRNumber"]) as cursor:
...     for row in cursor:
             # get all combinations of SRAddress & SRNumber
...         valueList.append(row[0]+str(row[1]))
     # make unique value set
... valueSet = set(valueList)
     # convert set to dictionary keys
... valueDict = dict.fromkeys(valueSet)
... with arcpy.da.SearchCursor("SR_Data",["SRAddress","SRNumber","Electronic","ItemCount"]) as cursor:
...     for row in cursor:
             # create comma-separated list of values matching each dictionary key
...         if not valueDict[row[0]+str(row[1])]:
...             valueDict[row[0]+str(row[1])] = str(row[2]) + ', ' + str(row[3])
...         else:
...             valueDict[row[0]+str(row[1])] = str(row[2]) + ', ' + str(row[3]) + ', ' + str(valueDict[row[0]+str(row[1])])
... with arcpy.da.UpdateCursor("SR_Data",["SRAddress","SRNumber","ItemList"]) as cursor:
...     for row in cursor:
             # write comma-separated list for each row, matching SRAddress & SRNumber
...         row[2] = valueDict[row[0]+str(row[1])]
...         cursor.updateRow(row)