How to output to seperate sheets and append a date to the filename too !

Hi guys,

Not sure if this has been asked before but i could not find anything.

I have an excel sheet which has a column based off which my workflow creates a file with multiple sheets. As i will be running this workflow every week, what i would like to do is create a new file every time it runs with a date appended to the file whilst also outputting the different sheets in that file. Currently the output data tool, based on my limited knowledge only allows to either append date to a file or create multiple sheets but not both. Currently my output tool option looks like this:

Thanks in advance.

Output

Accepted answers

JosephSerpis

Hi @saurabh79 that is possible might be worth changing the dropdown to change the output tool to entire file path and before the output tool use a formula tool to create a filepath with a date inlcuded. like C:\Report\"weekly_Report"+"[Date]"+".xlsx|"+[Column]

All comments

JosephSerpis

saurabh79

Thank you JS420. Is it possible to include a sample workflow showing how it would work? I did try your solution but i cannot seem to get it to work. Also, i noticed that the filepath in your solution isnt within " " and the date filed that is created is within " ".

Thanks again !

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703