A workflow of one of our Alteryx business users ended with a timeout, and only part of the data was written in the output. This leads to wrong data for the reports.
The goal should be:
It is not allowed that output data is only partially written the output. Either the output is written completely or no output will be created. Would it be possible to achieve this?
This behavior ( Either the output is written completely or no output will be created) is already available in Qlikview and expects the same to be available in Alteryx as well.
Database systems, and seemingly Quickview, have the ability to create "transactions" that will either write all data or no data. They can do this because the database has full control over the database.
Alteryx Designer is writing to different file types and doesn't have this ability because it's not in total charge of the files or databases. For example, if it's updating 1 million records in a database, it's not saving the previous values of the field being updated, so it would have to way to undo those updates if the workflow experienced an error later in its processing.
Alteryx product team should consider this and implement it in the future to solve many problems.
