Replace data in SQL without rewriting the whole table
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks, @jrgo . Using the output tool connected to SQL server I could write sql statements to update my data and delete data dynamically.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
