Hello Guys, please guide me on the below..
In a single project, I have 4 excels output from 4 Render tool..
All 4 excels have a single sheet and it contains data in table form.
Which tool or function I can add after or before Render so that I will get only one excel output instead of 4.
And this 1 out will contain data in 4 different sheets..
Cheers
What kind of ouptut are you putting into the render? Tables/Charts etc?
You can use the reporting tool palette to put your workflow into four tables/charts/etc and then use union to combine them - then put them in render.
NOTE:
you may have issues in page sizing/formatting if you have differing amounts of columns and differing widths on the tables you are placing into excel. Obviously this is not the case if you are using a filename/path option to create differing sheets.
Here's a general article on using filepath/name to output to separate sheets in the same file.