Urgent: Update Rows in output Table Using Workflow Field

Djaber

Hello everyone, 

Please do you know how can i update a field in an SQL database using results of the workflow ?

Example: update destination set Name = Workflow.Name  where Id = Workflow.id 

Is it a limitation of Alteryx ? no it's a basic operation !! but i don't know how can i make it..

Thanks in advance 

carlosteixeira

Hi @Djaber how are you?

if i undertood what you need, you can config this in the OutputData when you set to save in database.

In picture you can see 4 options:

Output Options - where you need config the metod to upload data in Database (in your case UPDATE)

Append Field Maps, where you mapping each field

Pre Create SQl - where you can put a query before execute update

Pos Create a SQL - where you can put a query after execute update

if i don't understand please let me know.

Best Regards