Skip to main content
Question

Can we update/delete/insert multiple attributes using feature writer ?

S

actually what I am trying to do is reading two GDBs one with updated values and one having old entries. Suppose in GDB 1 there are entries like 1,2,3,4and 5 and in updated GDB2 the entries are like 1,2,4,& 6. So I don't want to create new GDB I just want to add entry 6 in GDB1 and remove entry 3 & 5 from GDB1. For finding out the change I have made use of Change detector but after that when I am trying to insert it in the GDB I am able to update just one feature type at once but not all feature types

2 replies

K
  • k1
  • April 5, 2019
Create an attribute called fme_db_operation. Set the attribute based on your criteria - use the values INSERT, UPDATE, or DELETE. On the Writer, it will respect those values by inserting some, deleting others, etc., but you should set the writer to UPDATE and your match field like OBJECTID so the record lookup wiil work for the update.
S
k1 wrote:
Create an attribute called fme_db_operation. Set the attribute based on your criteria - use the values INSERT, UPDATE, or DELETE. On the Writer, it will respect those values by inserting some, deleting others, etc., but you should set the writer to UPDATE and your match field like OBJECTID so the record lookup wiil work for the update.

But what if we have different primary key for different feature class of gdbs and we want FME to detect on its own what are the things to update, delete and add.

Reply


Helpful Members This Week

Community Stats

31,105
Posts
117,929
Replies
38,858
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.