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

Alteryx designer Discussions

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

Options in Output tool

Alteryx Certified Partner

The In-DB help file has info (even the SQL UPDATE command structure), but I can't see the same for the standard Output Tool help file.

https://help.alteryx.com/2018.4/LockInOutput.htm?Highlight=output%20data%20update

 

You'd *think* that the same command would be issued for both in-DB and Std Output tools, but given that they differ in options on how an Update is done then it must differ in some manner, and is hopefully documented somewhere that I haven't found yet!  (NB: when I first starting using the the tools a few versions ago the Update didn't exist as an option, so I've done workarounds (ie. read full dataset in, update existing rows, union new rows, then delete & append full dataset in output (using temp table before write if using inDB tools to avoid deleting the select from dataset!)) and so I haven't tested this newer Update option in either toolset)

 

However, given that this thread identified earlier that Alteryx sends different commands to different DB products (ie. TRUNCATE to Kane's sql instance (not sure of product, maybe MS?) but a DELETE to IBM Netezza), quite possibly the UPDATE structure differs - with or without some kind of documented or syntactical reason..

Labels