In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Replace data in SQL without rewriting the whole table

LinhNguyen
8 - Asteroid

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!

 

3 REPLIES 3
jrgo
14 - Magnetar

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
8 - Asteroid

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

peiqingluo
5 - Atom

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?

Labels
Top Solution Authors