Render tool creating multiple files

Hello,

I have a workflow currently set up to run as an analytic app (AA). The user selects the file input and answers a drop down question. From there, the workflow runs and configures the input into tables, and then uses the render tool to output the data into one excel sheet with 3 sheets.

However, if the AA is ran again with the same file input, the render tool then creates 3 files (1 for each sheet). Any reason this is happening? Even if I delete the first file this still happens.

Reporting

Settings

Output

Help

Accepted answers

CharlieS

I'm going to recommend you take a different approach to rendering the sheets and updating the file path.

- Check out my attached example on how to render multiple, named sheets. The trick is in the Layout tool to arrange "Vertical with Section Breaks" (since section breaks = sheet in Excel), and do it by Group, and assign a "Section Name" with the dropdown at the bottom of the Layout tool.

- The above process with handle your sheet names, so now you can add a Formula tool to update the primary file path. This formula is easily edited with an Action tool in apps. The Render tool settings will replace the entire file path with the value from this Formula tool and the Layout is handling the sheets outside of this.