I am using write range activity to write data table to an excel file. I am giving the name of file in this format- 20210527.xlsx, i.e., yyyyMMdd.xlsx
The problem with this is, if on the same day the process is run more than once then the file will be overwritten. I do not want this. If the process is run 2nd time then the name of the file should be 20210527_1.xlsx, for 3rd time it should be 20210527_2.xlsx. How can this task be accomplished in the best possible way? With best I mean using very less activities and without complicating the workflow. If there is vb.net method to do so or something like that please suggest. I have come up with a solution of using Path Exist activity, while Loop and concatenating the file name string variable with “_countVariable”.
Is there any other better approach?