Skip to main content
  • EN

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.

 

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

30,168
Posts
114,524
Replies
37,824
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.