Seeking Creative Solution: Merging data in ArcMap 10.2

2857
2
07-16-2014 09:25 AM
TaylorKerr
New Contributor II

Hello!

I am calling upon the users of this forum to submit their creative solutions to a problem I have.

 

The Problem:

     I need to take data from ColumnA in ShapefileA, and merge it with empty ColumnB in ShapefileB.

 

         ShapefileA                  ShapefileB                  End Result                        

ColumnAColumnBColumnB
123<null>123
456<null>456
789<null>789

 

My Solution:

     I tried using the "Append (Data Management)" tool for this job, and it kind of did what I needed. ShapefileB gained the data from ColumnA, like I wanted, but the Append tool created a duplicate feature with those new values, instead of using the feature that was already in place. End result: I got the feature that I wanted, but the original feature I wanted to use was left behind and now needs to be hunted down and removed.

 

Your Turn!

    What process would you use in order to get to the desired end result?

0 Kudos
2 Replies
DarrenWiens2
MVP Honored Contributor

Can you expand on your problem? Your example makes me think you simply want to copy ShapefileA and change the name of ColumnA to ColumnB.

0 Kudos
DanPatterson_Retired
MVP Emeritus

If the geometry is the same in both files and they share the same feature ID, have you ruled out a "join"?

0 Kudos