Use Outputs of 3 Basic Tables and combine it into one Excel sheet(1 Tab for Each table)

[yatish1164]

 

Hi All,

I have this workflow which does multiple calculations and  I am finally left with 3 Basic Tables. I want the output of these 3 tables into one single excel sheet, however each table should be on a separate tab. Each Table has a different schema (Number of fields and number of rows too). I have tried the Visual layout tool to combine these 3 into one sheet, however, I am unable to then split them into separate tabs in Excel. 

Any help is highly appreciated! 

[Nanoq]

Is there a reason you're making reporting tables? otherwise you can just add a column to each defining the table name and choose the change table name setting in each output? 

[messi007 · Accepted solution]

@yatish1164,

Below how you can do it

 1- Add a layout after each table and you specify the section name

2- Union the 3 tables

Attached the workflow,

Hope this helps,

Regards,

[yatish1164]

I simply knew being a Messi fan would come handy someday! Thank you @messi007 

[yatish1164]

Yes Nanoq, it uses reporting tables for the optics my senior leads would like to see (Formatting and color coding etc)

[atcodedog05]

Hi @yatish1164 

Here is another way of doing it.

Workflow:

Output:

Hope this helps : )

[yatish1164]

Thank you @atcodedog05  ! This is handy too 🙂