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