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
Hi @fl
I recommend to union the output and the other 2 inputs.
Which will resolve your issue.
Many thanks
Shanker V
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
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
yes, in 3 different sheets of one file @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
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
@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.