How to update an existing field?

Question

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.

ciarab · Answer

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

How to update an existing field?

1 reply

Community Stats

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute