Append data to existing output file after every Run with new version

[azkh]

Hello Alteryx Family,

I am trying to append my data to the existing output file after every Run, but I also want that version No. gets changed after every Run

So If I Run the workflow 1st time it will give an output of 4 rows, but when I run my workflow 2nd time the version gets incremented by 1

[binuacs]

@azkh your use case is almost similar to the one given below. You need to keep your version number in separate file and increment each run and update the same file with the updated version number  

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Create-a-Counter-column-in-alteryx/td-...

[azkh]

@binuacs this only does the half part for me 10001 changes to 10002 now If I Runs my workflow again then 10002 will increment to 10003
so the expected output is
10001

10001

10001

10001 then 2nd RUN

10002

10002

10002

10002 then 3rd RUN

10003

10003

10003

10003

[binuacs]

@azkh you need to create two output file one for saving the version of the current run and other for appending your output file. please find the attached workflow

[azkh]

@binuacs I am trying this but the version in repeating again and again what I want is it should increment but not repeat

Version will be same for first RUN when I RUN it second time then only it will change

[binuacs]

@azkh please make sure you have two input file and one specifically for the version numbering and other one is your input file. The same version file can be used as one of the output file which saves the incremented version number, the other one can be your output file.

Another thing only keep the latest version number in your input file. the attached workflow working as expected , please see the first three run given below. 

if still not working please upload your input file along with your workflow and expected output file as well

First run 

Second run

Third run