AnsweredAssumed Answered

Arcpy - search duplicate attributes, then update values

Question asked by timdunlevie on Jan 29, 2015
Latest reply on Feb 3, 2015 by xander_bakker

Hi all,

 

Could someone point me in the right direction.

I have limited python scripting experience but know a enough (to be dangerous).

 

This is what I want to do.

 

I have a shapefile which has duplicate objects based on an "ID".

Object1: ID1 + Owner1

Object2: ID1 + Owner2

Object3: ID1 + Owner3

in this example there are 3 objects with identical ID but with 3 different owners for the same object.

 

What I want to do is search through the shapefiles for all identical "ID", then update a new shapefile with :

 

Object1: ID1 + Owner1 + Owner2 + Owner3

 

The new shapefile would have 3 extra columns added for the Owner field to be updated to.

so I want 1 object only but keep the owner information in the row.

 

thanks,

Tim

Outcomes