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!
Solved! Go to 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.
Thanks, @jrgo . Using the output tool connected to SQL server I could write sql statements to update my data and delete data dynamically.
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?