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

Alteryx Table Doubt.JPG

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!

Alteryx Table Doubt.yxmd

Reporting

Accepted answers

messi007

@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,

Alteryx Table Doubt.yxmd

All comments

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?