Skip to main content
Question

The FME script is deleteing my manually added attributes in writer SQL table, how do I keep them?

  • March 18, 2020
  • 1 reply
  • 6 views

souryana
Contributor
Forum|alt.badge.img+9

Hi,

I have a script where I read from a table, lets call it A, to another table, lets call it B. In table B I have added a number of columns (and attributes in those columns) that doesn't exist in table A. This script needs to be automated. However, what happens is that it deletes the attributes that I added manually. I dont want that to happen. What I want for table B to do is:

1. ONLY update columns that derives from table A.

2. DO NOT delete attributes that only exist in table B

How should I proceed with this issue?

1 reply

Forum|alt.badge.img+2

@souryananassera The tutorial Updating Databases: Updating Individual Fields of a Record explains how to update only some fields in a record. Simply remove the attributes you do not want to update form the feature - i.e. AttributeManager or AttributeRemover.


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