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.

Workflow

SakshiBan
7 - Meteor

Hi, I have my final Workflow Output ready (Having 3 Different Tabs) through render tool but i want to Include another 2 tabs in this final output. The another two Tabs are nothing but are my two Input files.

 

Can anyone please let me know how I can do that?

3 REPLIES 3
Kamran1991
11 - Bolide

Through render tool, you can't generate  multiple tab. This is possible through macro only.

CathyS_Slalom
9 - Comet

Hi @SakshiBan, maybe what you could do is to use the Parallel Block until done tool to create the separate tabs for your input files after your generated your output (3 different tabs).

 

You can download the tool from here: http://downloads.chaosreignswithin.com/Macros.zip 

 

Useful post - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Parallel-Block-until-done/td-p/829080 (including a video that shows parallel without CReW macro.

danilang
19 - Altair
19 - Altair

Hi @Kamran1991 

 

You can actually render as many different tabs as you'd like to an excel file, each with different schemas.  The trick is to pass all your data through table tools and then use a layout tool to specify the tab names.  

 

danilang_0-1649508955644.png

This works because what comes out of the table tool is a report snippet and all report snippets have the same column Type and size.  In each table tool, make sure to group by the tab field and don't include this in the actual columns

danilang_1-1649509134100.png

 

In the Layout tool, select Each Group of records as layout mode, group by the Tab field, Choose Vertical with Section Breaks  as the Orientation and Select Tab as the section name.  

danilang_2-1649509493133.png

 

 

Dan

 

 

 

 

Labels