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
  • 14 views
souryana
Contributor
Forum|alt.badge.img+11

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?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

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

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.