Dynamic Output Tool

[JoshKushner]

Just like the dynamic input tool, a dynamic Output tool would allow us to write to a database, wait until done, and then use the primary keys generated from that output later in the workflow.

Without dynamic output, we are forced to modify our database table structure or "hack" the dynamic input tool as a work-around.

It would be very useful if dynamic output tool had the same options as a regular output tool (e.x. append, update, overwrite, etc.)

[SeanAdams]

Fully agree with you @JoshKushner

Have a look at this post: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Output-tool-with-an-output-node/idi-p/83264

This would also work if we had a SQL tool that can issue arbitrary SQL statements with an output tool.

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Have-an-SQL-Tool/idi-p/5392

But yes - very much agree, doing what you say is quite tough right now - as is using the inserted or deleted virtual tables in SQL to only process rows that have been changed by a SQL statement using an output clause.

https://docs.microsoft.com/en-us/sql/t-sql/queries/output-clause-transact-sql?view=sql-server-2017 

[ctrl_kudorje]

@SeanAdams  AND @JoshKushner - I didn't find an update on this idea. Is this now available in Alteryx's version 2018.4.5?

[SeanAdams]

hi @ctrl_kudorje  - the idea is still in "New Idea" status which means that it has not yet been included in the main product.

[ctrl_kudorje]

@SeanAdams  - Thanks will keep an eye out.