community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

In-Database Update and/or Delete

DELETE from Source_Data Where ID in

SELECT ID from My_Temp_Table where FLAG = 'Y'

 

.... 

 

Essentially, I want to update a DB table with either an update or with the deletion of rows.  I can't delete all of the data.  My work around will be to create/insert into a table the keys that i want to delete and try to use a input/output tool with SQL that performs the delete.  Any other suggestions are welcome, but a tool is best.

 

Thanks,

Mark

44 Comments

This really needs to be added for other platforms, like Teradata for us. A lot of companies don't use SQL server and still require this functionality.

We also really need this for PostgreSQL !

Meteor

I don't see the 'Delete Rows' or 'Update Rows' options when using the In-DB Write Tool.

 

Running 2019.1 and connecting to an Azure SQL Server DB using v17 ODBC drivers.

 

@MarqueeCrew @AlexP - any ideas?

 

Many thanks in advance!

 

alt.png

 

It'd nice to be able to run ANY Sql query from the INDB tools.

Example : in my PostgreSQL db, i'd like to be able to run such queries from Alteryx :

comment on column "ERF_MCHB_MCH1"."WERKS" is 'Division';