Combining the Rendered Table report with other Excel sheets

euginalim

Hi everyone,

I have searched the community inside out for this answer, but I am not finding anything. Please help!

I am trying to output my Table report and the original dataset to the same excel file, but on different tabs, using Render and Output tool. Please see below for a picture of my current workflow. 

Ideally, I want to output the Table and original data in the same file, but every time I do this, the file outputs only the table and outputs the "Above 50k" tab but it is a blank sheet.

FYI, I have a "Block Until Done" tool set up  - just not pictured in the screenshot - so the table is outputted first and then the original data tab. So this is not an issue of timing. Also to clarify, I wish to get this job done in one workflow, rather than create another workflow to input two different excel files and output to a combined file, because I have multiple tabs and files to run this workflow on. It would be an annoyance to run two workflows every time. 

Is it impossible to combine these two reports in one excel file with one workflow? Thanks in advance! 

danilang

Hi @euginalim 

Check out the technique used in the solution to this post.  The very clever @DavidP has solved this problem by moving the block until done to just before the report preparation.  One of the key things he mentions is that the render tool actually creates both sheets, but puts only dummy data in the one that gets over written by the output tool.

Dan