Output the render results as 1 file contains three different sheets

[fl]

Hi everyone, i m currently using  the tool 'render' to output tables and ordinary output tool to output other results, how can i combine  these 3 output files into a single excel file (i can combine the ordinary ones but when it comes to render tool that won't work) below is a simple example, thank you in advance  

the old method i use is output the rendered file and then re-input it as a new input and then put these three in a same file, now i need it to directly output to the file

[ShankerV]

Hi @fl 

I recommend to union the output and the other 2 inputs.

Which will resolve your issue.

Many thanks

Shanker V

[ShankerV]

Hi @fl 

Hope this helps!!!

Many thanks

Shanker V

[fl]

thank you so  much @ShankerV, maybe i didnt state the question clearly enough, these three output should be as 3 separate sheet in one file

[ShankerV]

Hi @fl 

In which format you are expecting to extract the output.

ie. in same excel sheet, in 3 different sheets?

Many thanks

Shanker V

[fl]

yes, in 3 different sheets of one file @ShankerV,

[ShankerV]

Hi @fl 

Please find the below output as expected in one excel but in 3 different sheets.

Highlighted in red is added in the workflow to reach the solution,

Many thanks

Shanker V

[ShankerV]

Hi @fl 

Step 1:

Step 2:

Step 3:

Step 4: Union tool

Step 5: Layout tool, highlighted in Yellow color need to be followed.

Step 6: Render tool gives the output

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V

[binuacs]

@fl I don't think you can write the same excel file which is being used in the render tool output with an output tool. If you try to write in the same render tool output file using an output tool it would corrupt the file.