Is it possible? Have a workflow output save into that same workflow when ran on gallery?

[Tybo]

I have a workflow that pulls from an Oracle database and exports an excel file with "current" data as well as a summary or pivot of the data to be used in Tableau to create charts.

I want to be able to accumulate the pivot data for each day the workflow is ran. When I run it today I want to see all previously ran data and today's data.

Is this possible to do within the workflow living in the Gallery so that the data is updated and saved with each day's run?

I've tried using the action tools to update a text input file or block until done to pull in the text input history and then union it but they either do not behave the way I need or I'm missing something. Also, since running a workflow doesn't save the new data, the text input data just reverts to how it was when the workflow was created.

I'm currently having to create a separate file for this but I want to automate this task as much as possible so all you have to do is download 1 file and refresh the data in Tableau.

I am using:

Designer ver. 2020.2.3 (Can't upgrade due to server/gallery version)

Expected result. Each day is essentially the same set of data accumulated each day. So I would only see Day4 as the latest version.

I can't upload the actual workflow but I think the table above can be used for the practical application. 

Here's the workflow picture though for the curious.

[BrandonB]

Could you leverage the "Append" output option? This places data feeding into the Output Data tool underneath the existing rows in the file and would stack the new information every time the workflow is run.

[Tybo]

@BrandonB I'm so sorry for taking so long to reply. Your solution does not work. The Gallery workflow seems to only remember the initially loaded file and does not retain the appended data. Only way I can think to make it work is to have an off server file that is kept outside of the workflow to be updated and then called upon for the next run with the appended data but that is exactly what I am trying to avoid. I want the Workflow to almost "re-save" after each run to build the source file up on each run so it's incrementally larger. It seems like what I want is not possible. Let me know if you have any other ideas. Thanks!

[BrandonB]

The only way to accomplish a larger file each time is either to re-query the data to pull the entire data set on every run which will grow due to the nature of the larger data set being pulled each time, or to take the approach that you mentioned in using potentially a yxdb file off of the server and appending new data to it on each run.