0

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.

asked Sep 30, 2015 at 8:07
2
  • does the databaseUpdater works for u ? Commented Sep 30, 2015 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. Commented Oct 1, 2015 at 6:54

1 Answer 1

1

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

answered Sep 30, 2015 at 9:04

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.