Output to new file every time workflow runs

[ferha_jafri]

Hello Experts,

I have a query in which I want to create new file as an output every time workflow runs. Basically I am generating different Tabs in one excel through output tool. So every time it is  possible that the value in Field to generate the different tabs have different value , so in this case I want to delete the old file completely and create a new file every time .

Thanks in advance.

[mceleavey · Accepted solution]

Hi @ferha_jafri ,

Are you saying you want to replace the file every time it runs, but the Tab will have a different name each time?

You need to create a formula, which will be <Filepath>+<filename>+"|||"+,sheetname>

You then configure the output to overwrite the file and create the new one with the new filename:

Hope this helps,

M.

[ferha_jafri]

I tried this it is working but the heading are coming which include File Name and Sheet Name which I do not want to be a part of my output, so how I can remove them.