Analytic App Output to a Single Excel File with Multiple Worksheets

[fimler]

I have an analytic app where the output could be several millions of rows.  I have configured the output to write to multiple worksheets in a single Excel file (APM_Output.xlsx) based on a field.  Everything works fine with the creation of the file.  The issue that I am experiencing is that if multiple worksheets are created, the App Results window (see below) shows the file multiple times - once for each worksheet that was created.  Is this a mis/missed configuration somewhere on my part or is this a bug?  If I click on "Ok" in the App Results window, Excel tries to open the file multiple times which leads to a "i...s open in another application.  Please close it and try again." error.  Can I do anything to keep this from happening? 

[apathetichell]

can you post a screengrab of your interface designer properties configuration?

[fimler]

@apathetichell 

Here is the Interface Designer Properties:

[mceleavey]

@fimler ,

this could be due to the grouping on the render tool.

If the render tool produces multiple outputs then having that checked in your interface designer will result in multiple files being shown.

M.

[fimler]

@mceleavey 

The Render Tools is not involved in the creation of the excel files.  I used the render tool to create a 100 row sample that is displayed to the user.

[apathetichell]

just a sec.