Question

How to update an existing field?

  • 22 September 2021
  • 1 reply
  • 63 views
M
Badge +1

I have an existing ArcSDE table with several fields but there is one field called 'state' that has no value. I want to assign the value 'NY' to this field with no conditions, so all records should have the field 'state' with a value 'NY'. I can do this in ArcMap or using SQL, but when I try it with FME using the Feature Writer it does not update anything to that field.

 

I have an Attribute Manager that sets the value 'NY' to the state field, I then connect it to the FeatureWriter

 

Feature Operation: Update

Table Handling: Use Existing

Update Spatial Column: No

 

Row Selection:

Columns: state

 

FME Desktop 2019

fme_0921 

Thank you.

 

1 reply

ciarab
Rank
Badge +9

That column selection is to indicate an identifier of which row to update ​.

​

The columns specified in the corresponding column picker dialog will be used for matching destination rows. All matching rows will be selected for update or delete

​

So as you have set it, you are searching for matching values in the state field to update those records and none currently match. You need to set it to a unique id and it will match that id and then update all the specified fields in the writer . If you only want to update state then remove all the other attributes .

​

Thats one way to do it anyway hope that helps

Reply


Community Stats

28,669
Posts
109,364
Replies
36,531
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.