cgallipeau

Duplicate Records - How to Merge Attributes from 2 Records Into 1

Discussion created by cgallipeau on Nov 20, 2012
Latest reply on Nov 20, 2012 by dlee-esristaff
I merged 2 separate shps into one master shp.  Now, I have a shp that contains many duplicate records.   Each shp contained some records that were also in the other shp as well as some unique records.  The ID #'s are the same (that's how I know they're duplicates).  I have a field that identifies the duplicate ID #s.  However, my problem is that certain fields contain data for some records but not for others and vice versa.  My question is how to get any data for an ID into one row, regardless of which layer it comes from.  For example, ID 01 in Layer A contains attribute info for fields 1, 2 and 3 but not for fields 4 5 and 6.  ID 01 in Layer B contains attribute info for fields 1, 2 and 3but not for fields 4 5 and 6.  I want one record that has attribute info for fields 1, 2, 3, 4, 5, and 6 for ID 01.  I assume this is a combination of joining and concatenating but so far haven't had any success figuring it out.

Outcomes