dynamic output filename on Render Tool

[L_Gordon]

Is there an option to enter a variable name to the render tool similar to an ordinary output tool?

[SubratDas5]

could you elaborate further - are you looking to download multiple files from the render tool or getting multiple splits of the data in a single document format 

[L_Gordon]

In a regular output tool you can create a field in the output stream that constructs the path\filename\sheetname.  On the output tool at the bottom you have the option to enter the file name.  Like this, and I want to do the same thing on the Render Tool.

[Lesley · Accepted solution]

Hi @L_Gordon,

This can be achieved by using the 'Group Data into Separate Reports' option in the Render tool. First, in your Table tool, set your dynamic field as the grouping field. Then, in your Render tool, set your our output mode to "Choose a Specific Output File" > specify your Output File > select your dynamic field as the field to group on as seen in the screenshot below.

Hope this helps! 

Lesley 

[L_Gordon · Accepted solution]

Thank you.  I have that piece worked out but also wanted to have multiple data sets saved to a variable file name with specific worksheet name.

Here is the configuration of the layout tool which would go into a render tool as you have described.  

[Pat360 · Accepted solution]

Hey all - 

Just spending my saturday messing around with the tools. This might help: 

This workflow allows you to dynamically rename an Excel workbook (also could be used for PDF, Word etc..) with separate Worksheet tabs. All worksheet tabs are also renamed automatically. 

- Also group one of the Excel worksheets by company name...you'll see :)

1. Text Input : 

2. Company List : (I want all companies on the first Excel worksheet tab)

  

3. Group Address by Company: (for the other Excel worksheet tab)

4. Report Output: 

- The Formula tool is the secret sauce for the dynamic rename of the file. I wanted a Datetime with an AM or PM to appear on the file name dynamically. Everything in the Formula tool prepends before the .xlsx extension. You must put an extension (.xlsx, .pdf, .docx)

You can see on the browse tool how it breaks it up into 2 Records. Those separate Records become the Worksheet tabs in Excel, or saparate pages in PDF or Word. 

THE FINAL OUTPUT:

And the Excel Workbook:

Hope this helps!