Writing the simple excel report in one tab and render output in another tab in Excel

[poojamate92]

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

[NexBK]

Reporting_Sample_Date.xlsx was not included in the yxzp file you uploaded.
Please upload it.

[poojamate92]

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.