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

Question

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

binu_acs · Answer

@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

append1.yxzp

azkh · Answer

@binu_acs 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

Workflow2.yxmd

binu_acs · Answer

@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

append1.yxzp