In-Database Update and/or Delete

[MarqueeCrew]

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

[MarqueeCrew]

here's a picture....

here's a video....

That's my 2 cents,

Mark

[ARich]

Hi @MarqueeCrew,

Thanks- we have a design to implement the functionality you ask for above. We want to validate that design, so please let us know if you can participate in a call this week or next.

Best,

Alex

[MarqueeCrew]

Shirley,

you can can count me in. 

[MJP]

Alex,

A question prompted by the example posted by @MarqueeCrew: Is the functionality being considered for In-DB or local tools?  I have a particular interest in the In-DB side since we work with fairly large data sets.  If you need input for the In-DB tools similar to what MarqueeCrew sent for the local tools, please let me know.

Thanks,

Michael

[MarqueeCrew]

I was just using the in memory tools for easy understanding given their intuitive anchors. This is all meant for in-dB. I was the originator of this thread. 

[MJP]

Alex: Please count me in. I would be happy to provide any input or feedback you think would be helpful.

MarqueeCrew: Got it.  Thanks.

Michael

[ARich]

Thanks, @MarqueeCrew and @MJP,

I'll be reaching out in the next week to coordinate a call! 

Opportunity is still open for anyone else who'd like to join- let me know!

Best,

Alex

[abartoszek]

How did this test go?  Do you still need testers?  Thanks!

[Joe_Lipski]

@ARich & @MarqueeCrew Has this functionality been included in the 2018.4 release? According to the release notes it seems like it has: https://help.alteryx.com/ReleaseNotes/Designer/Designer_2018.4.htm

The Write Data In-DB tool now supports the conditional update and deletion of rows in a SQL Server table (ODBC) based on incoming records.

[ARich]

This has been implemented for SQL Server in the 18.4 release!