Overwrite / update data in the same database (SQL server managment)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
 
Solved! Go to Solution.
- Labels:
- Database Connection
- In Database
- Input
- Output
- Updates
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @JosephSerpis !!
