Write Data In-DB Tool - Output anchor ?

[Benji27]

Hello everyone !

I have a question about the Write Data In-DB Tool: indeed I see an anchor with a grey color as output of this tool

But what kind of another tool can I connect to it ?

Do you know  ?

Thanks for your help !

[DataNath]

@Benji27 whenever you see a grey anchor (input or output), this means that connecting to it is optional. Whereas, if an anchor is green and gets left empty you’ll get errors in your workflow.

In the case of Write In-DB, this basically allows you to either stop your workflow at writing to that table, or you can continue processing the data if you perhaps want to make extra changes and output to more tables, do more analysis etc further along. In terms of the type of tools then you’d continue using the In-DB palette, unless you stream data out into Alteryx in which case you can use regular tools.

[Benji27]

Thank you @DataNath for your quick reply !

In fact, I would like to execute an SQL instruction (delete rows from an another table) just after the Write In-DB tool but I don't know how to do that :(

Do you know an InDB tool, can execute SQL instruction and just after execution of this Write In-DB treatement ?