Multiple tabs under one Output excel sheet from 2 different Input files

[Vikas27]

Hi Community

I'm struck with an issue. I've 2 different Input files (which are basically the output from the workflow) one i created from Output function and other has 2 tabs created from Render function. 

Now, i've given 3 Input data separately i just want all 3 of them into one Output file as my end result. I tried using Union function but Union gave me all data under one sheet. I want simply the data as it is in 3 different tabs. 

Can someone advise how can i get that?

Best Regards

Vikas 

[DataNath]

Just need to change the configuration of your output tool to take date from whichever field has a unique value in to separate with. More info here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-output-multiple-tabs-within-a-s...

[Vikas27]

@DataNath I tried changing the configuration but doesn't help. Do i need to change on Output file? If Yes, how can i create multiple tabs under one sheet. Thanks. 

[Brian_Barnhart]

I have a workflow with multiple inputs, I use a union then select tool to clean up the data and then add filters.  The Block until Done tool ((Developer Tab) pauses teh workflow so its not trying to write the tabs all at once, which will error out. From each filter I have the same output file name BUT, I rename each sheet and that produces multiple tabs.  

[Vikas27]

@Brian_Barnhart i actually want all 3 inputs in same format as they are just into one sheet multiple tabs. These 3 inputs are my outputs but since they are combination of (Output data+Render) I can’t combine them. 

can I simply match Input data with output data tool and then give tabs. Will that work. Any idea? 

[binuacs]

@Vikas27 I created a macro which will combine all the three files data (read from the different tabs) and combined into one later it will save in the same file but different tabs.

[Vikas27]

@binuacs - If i give 3 files as input than the Render function I used to create table with border gets over. So this didn't worked. I created Render tool for the first output file and increased the width. it worked though width looks quite expanded for 2 of the tabs but atleast my basic requirement of having all 3 data sets in one excel happened. So i'm satisfied with the result.