Skip to main content

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