Hi Team,
This is my first time I'm using reporting tool. I wanted to generate a simple excel output and the render output in one excel file. Can anyone please help me to achieve this ?
I've created one sample workflow for this -
e.g.
Input 1-
The Input 1 written to the excel report. File name called Reporting_Sample_Date.xlsx and tab - Table1
Input 2-
Inner join between Input 1 and Input 2 and used table tool as -
Input 3-
Used the table tool for Input 3 and merger the above two tables and use layout and render tool to output the report. Below snap shows the complete workflow
So I wanted the output as Reporting_Sample_Date.xlsx which will contain two tabs as Table1 and Table2 where table1 has the simple excel output and Table 2 has the render output.
Do we have solution for this?
Attached is the sample workflow and outputs.
Pls note - currently workflow generated two outputs -
Output 1- Reporting Sample_2207_220808 (Contain simple exel data)
Output 2- Pivote (Contain render output)
However, I need both the above output in same report as different tabs
Reporting_Sample_Date.xlsx was not included in the yxzp file you uploaded.
Please upload it.
Hi Meteor
Please see the sample outputs attachments in my post. Currently workflow generating two outputs one for simple excel table and another for render. But I need one file contain both the reports in separate tabs.