Select to view content in your preferred language

Calculate Field help

3332
5
11-03-2015 09:46 AM
JB
by
Emerging Contributor


I was working with a shape file that contained a lot of data when I went to calculate a field and for some reason it took out all the data and left me when only that calculated field which is has never done to me before. Is there a way to reverse the calculate field so I can see all my old data? thank you in advance for your help!

0 Kudos
5 Replies
DarrenWiens2
MVP Alum

Do you mean it calculated all the records in the calculated field to NULL, or did it remove all the fields outside the calculated field, or something else?

0 Kudos
JB
by
Emerging Contributor

Sorry about that. It removed all fields that were outside of the calculated field.

0 Kudos
JoeBorgione
MVP Emeritus

Is there a way to reverse the calculate field so I can see all my old data? thank you in advance for your help!

Ouch...  Two things for next time:

When calculating large numbers of rows, start an edit session.  If things go south, just close without saving edits

Backup your data.  If your data is on a network drive, buddy up to the IT guys (beer, candy bars, etc) and see if they can restore what you have lost.

That should just about do it....
TimWitt2
MVP Alum

Joe pretty much summed it up. If you could mark his answer as correct, that would be great!

0 Kudos
ChrisSmith7
Honored Contributor

Also, in the event that your data are priceless (assuming it's not backed-up by your IT dept.), you could try, as a last resort, restoring from a previous version:

Recover lost or deleted files

You may want to check your scratch workspace as well for any intermediary files in processing that could have salvageable data. And, as a super last resort for priceless data, you could try forensic data recovery, assuming you haven't overwritten the sectors on the hard drive.