Replace data in SQL without rewriting the whole table

Question

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 Answer

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 Answer

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