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.
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
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.
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!
