Select to view content in your preferred language

Making a "joined" field permanant in my database

830
4
12-26-2013 05:56 AM
MikeHenson
Regular Contributor
I have a database (shapefile) that has a joined table to it.  I need a field that is in my joined table to be a permanant field in my shape file so I can remove the join, but still have the field.  I thought I could just calculate a field, but when I do that it is still showing up as a joined field.  Can someone tell me how i can do this? Thanks.

MKH
Tags (2)
0 Kudos
4 Replies
TimWitt
Deactivated User
If you are in an MXD, after you perform the join, right-click your layer and click Data -> Export Data...

The new shapefile should have the join in it and permanent.

Or you could use this tool, to make it permanent.
0 Kudos
JoshuaDamron
Deactivated User
Note: I believe that if you export your data any metadata you have created is not carried over in the export and will have to be recreated for the new feature class.
0 Kudos
NidhinKarthikeyan
Honored Contributor
The join should be made permanent for calculating the field.

Metadata will be carried over in the export.
0 Kudos
JoshuaDamron
Deactivated User
Metadata will be carried over in the export.


Thank you for the correction Nidhin, I didn't check my facts and was mistaken about metadata being carried over.
0 Kudos