Render Tool with Multiple Sheets but One File Name

I am outputting a file using the render tool. I have the file exporting to Excel with 7 different sheets. I need to know how can I add the date to the file name. I know how to do it using a normal output tool but not sure how it works with the render tool. Can anyone assist?

Thanks!

Reporting

Accepted answers

AbhilashR

Hi @BrandonS4, you don't have to use a union tool to append date to your file name. Just include a formula tool before Render, and reference it within the render tool. Something like the below:

The configuration in the Render tool would look something like this:

The solutions provided were meant to illustrate the art of possible.

All comments

AbhilashR

Hi @BrandonS4, I have attached a sample solution, is this what you are looking to achieve? The workflow

create a date field in the formula tool, which gets prependend to the output file name in the Render tool.

sampleReporting.yxmd

DavidP

Here's an example of a workflow that creates 2 sheets in an excel and then adds the date to the filename

render tool to excel multiple tabs.yxmd

BrandonS4

Do you have to use the union tool because of the render tool? You don't have to do this when doing a normal output, correct?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703