community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Update Rows using Write Data In-DB tool

 

 

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

 

Inactive User
Not applicable

In-DB Tool does not have delta logic capability. You will see by default when you create your connection the output it suggests using Bulk Loaders as this function is not available. I would stream out and perform the delta logic on the PK as you have been.

Highlighted

I’m not sure what you mean by delta logic – the documentation on the Write Data In-DB tool indicates the update rows is possible (and I think it works for SQL in particular) and the query structure examples on the page are similar to what we would write manually. Would changing the write driver help in this case? What determines if “Update Rows” appears or not with this tool?

Meteor

@SSteckler did you figure this out?

 

I am having the same problem. I found the original discussion of this feature and confirmation that it should be present as of 2018.4, but I can't see the 'Update Rows' and 'Delete Rows' options that are supposed to exist..

 

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/In-Database-Update-and-or-Delete/idc-p/19284...

The only advice I have got is to use the Output Tool to write to the database.  This solution works fine (maybe a little slow, but my data sets are relatively small), but I've never got an answer on why the "Write Data In-DB" tool won't do it.

Labels