lygismav

Complex dissolve - dealing with comma separted values

Discussion created by lygismav on Mar 11, 2013
Latest reply on Mar 12, 2013 by dhoneycutt-esristaff
Hello,

I am trying to figure out the best way to dissolve by attribute when the field may contain more than one value.  For example, I have a list of parcels that may have several ditches assigned to that parcel.  I would like to create a layer that shows which parcels contain ditch #1, which contain ditch #2 etc.

Parcel              Ditches
42-001                1,2
42-002                 1
42-003                2,3
42-004               1,2,3
42-005                 2
42-006                 3

Expected Result 
Ditch 1 - contains the area for parcel 42-001, 42-002, 42-004
Ditch 2 - contains the area for parcel 42-001, 42-003, 42-004, 42-005
Ditch 3 - contains the area for parcel 42-003, 42-004, 42-006

Thanks

Outcomes