Seeking Creative Solution: Merging data in ArcMap 10.2

TaylorKerr — Wed, 16 Jul 2014 16:25:33 GMT

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

ColumnA	ColumnB	ColumnB
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?

Re: Seeking Creative Solution: Merging data in ArcMap 10.2

DarrenWiens2 — Wed, 16 Jul 2014 17:06:53 GMT

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.

Re: Seeking Creative Solution: Merging data in ArcMap 10.2

DanPatterson_Retired — Wed, 16 Jul 2014 17:36:07 GMT

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

topic Re: Seeking Creative Solution: Merging data in ArcMap 10.2 in Data Management Questions

Seeking Creative Solution: Merging data in ArcMap 10.2

Re: Seeking Creative Solution: Merging data in ArcMap 10.2

Re: Seeking Creative Solution: Merging data in ArcMap 10.2