Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Overwrite / update data in the same database (SQL server managment)

Highlighted
Alteryx Partner

Hello community!
I have a problem, I have the following image that is part of a larger workflow. The problem is that I want to append new data (green box) in a sql database (purple boxes) and as I show in the image I am reading and writing in the same database and at the same time. I think that has created conflict on Alteryx because the flow never stops.

 

Is there a way for the flow to end up to the union tool and then write the data? or maybe IN-DB tools can help

 

PD: new data comes from IBM as400

 

Please help me
Thanks!

Sin título.png

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @Danielht have you tried using a Block Until Done Tool before the Output tool as this would gather all the data in your workflow then push the data into the Output Data Tool?

Highlighted
Alteryx Partner

Thanks @JosephSerpis !!