Dynamic update to SQL Table in Alteryx Output

[kafka_u21]

Query as i am still learning Alteryx.

I need to write a SQL script in "Text Field", which could either be "Update" or "Insert" statement into any table in my database. from the INSERT/Update SQL statement written in "text field", I need to identify the table and push the data into the database. Is it possible to do it?

[danilang]

Hi @kafka_u21 

Since the table is embedded in the Output tool connection string, you can put your output tool in batch macro and have the control parameter of the batch macro change the table name as required.  Make sure your data input has Show Field Map unchecked so that you can pass any columns to it.

Dan

[apathetichell]

You can also do the same with datastream in vs an output data tool (depending upon your DB - you may need to do this) but the keeping your output in a batch macro is sagely advice.