Need to change which field is the index field because export tool janked my stuff

Question

Hi.

So I posted on here a few days ago about how datareviewer really screwed me over and I have no resolution.  I've finally figured out that it didn't just jank my atts, it reorganized the revtablemain so the records are not in their original order anymore.  This is a real turd in the punch bowl.

I've done a couple joins for the revpolys and i have them (well, a filed) associated with their original revmain entry.

The problem is I need to reindex the table (and probably the features) based on this new field I have calculated.

How can I do that?  It won't let me remove the OID as the index field because it is "required"

please and thanks.

-RC

RandyCrumley1 · Answer

Man, so close.  It exports it and makes the index field "objectid_1"  I need it to be RecordID.  I think i can create a blank table and import it maybe.

RandyCrumley1 · Answer

Just found a gp tool called "sort"

I think that is what I need.  Will mark as answer if it works out.