Skip to main content
  • EN

Hello. I am trying to make a transformation in the values of a certain field called Labeltxt in a feature type in a gdb. I change the value in the field. This succeeds, but when I need to write back into the gdb i have a problem:

 

Either i use "drop and create" in the writer, but then the objectID field is re-written, which we use to relate to other tables.

 

Or i use the "update" "use existing", and then select "labeltxt", but then the field is not changed in the gdb that is written.

 

Is there a way that I can retain the Object ID and also change the labeltxt value?

 

Regards Rasmus

You need Update and Use Existing, and select ObjectID in Row Selection Columns.

 

2021-03-29_12h03_54

Thanks, that did the trick :)

While @nielsgerrits​  answer is correct, I would strongly recommend against using an ObjectID as a "unique identifier" as ObjectIDs change change. If the data is copied or moved between databases, the object ID might change. I'd reccomend have a seperate GUID type field setup that you can use for any relationships that may be required

While @nielsgerrits​  answer is correct, I would strongly recommend against using an ObjectID as a "unique identifier" as ObjectIDs change change. If the data is copied or moved between databases, the object ID might change. I'd reccomend have a seperate GUID type field setup that you can use for any relationships that may be required

I second this. I was assuming he had no other id field available.

Thanks for the advice. Yes, we realise that this was a mistake. But we have a massive database built on this system, so it is too late to change now unfortunately.

Reply


Community Stats

30,179
Posts
114,557
Replies
37,844
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.