Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

yatish1164
7 - Meteor

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! 

6 REPLIES 6
Nanoq
8 - Asteroid

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? 

 

Nanoq_3-1633096267419.png

 

 

messi007
15 - Aurora
15 - Aurora

@yatish1164,

 

Below how you can do it

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

 

messi007_1-1633096993446.png

 

2- Union the 3 tables

messi007_0-1633096935419.png

 

Attached the workflow,

Hope this helps,

Regards,

yatish1164
7 - Meteor

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

yatish1164
7 - Meteor

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

atcodedog05
22 - Nova
22 - Nova

Hi @yatish1164 

 

Here is another way of doing it.

 

Workflow:

atcodedog05_0-1633103844238.png

 

Output:

atcodedog05_0-1633103916229.png

 

Hope this helps : )

yatish1164
7 - Meteor

Thank you @atcodedog05  ! This is handy too 🙂

Labels