I have built a workflow in FME2015 in which I use SQLExecutor to run a query. I want to use the result of the query to UPDATE a column of table in my database. I am having difficulties in passing the results into the table using a postgis writer with a writer mode in UPDATE. I attach a screenshot of my workflow:

enter image description here

The column I want to update is called: nettype. And I need to update it based on the key: fr_gid. If I understand correctly I need to use the fme_where attribute but I am not sure in what way.

  • does the databaseUpdater works for u ? – Jorge Vidinha Sep 30 '15 at 14:11
  • 1
    I think the databaseUpdater can do what I want but in the end I used the SQLExecutor with the appropriate UPDATE query. – user1919 Oct 1 '15 at 6:54

Use tranformer databaseUpdater Update fields in a database table based on the condition specified.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.