Replace data in SQL without rewriting the whole table

[LinhNguyen]

I have a large SQL database and after transforming/replacing some of the data in Alteryx, I want to write it back to SQL without rewriting the whole SQL table. I found how to append new data to an existing table but what I need is to replace part of the data. Is there a way I can do that?

Thank you!

[jrgo · Accepted solution]

Hi @LinhNguyen 

If the table you're updating has a PK designated, the output tool does provide a few UPDATE actions depending on the database platform you're connecting to.

[LinhNguyen · Accepted solution]

Thanks, @jrgo . Using the output tool connected to SQL server I could write sql statements to update my data and delete data dynamically.

[peiqingluo]

Want to dynamic delete part of a table basing on a filter or replacing part of the table in Output tool. Is there a way to do it?