We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Update Rows using Write Data In-DB tool

SSteckler
5 - Atom

 

 

I am trying to update existing rows in a database table.  I can do it by streaming my data out and using the Output Data tool (so I know I have the right permissions, etc), but I can't figure out how to use the Write Data In-DB tool to do the same thing.  I don't even see the Update Rows option in the Output Mode dropdown menu (I have updated to version 2019.1).  I've checked that the field names, and number of fields all match.  What  am I missing?

Write InDB.PNG

 

10 REPLIES 10
philipc
5 - Atom

Limitations: Update/Delete is currently only supported for SQL Server ODBC connections. Any updates on this limitation? I was trying to update a column in a  postgress database table. Failed with this error message  "Primary key required for update option"

Labels
Top Solution Authors