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

Question

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

Vikas27 · Answer

@binu_acs - 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.

binu_acs · Answer

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

Combine_Files.yxzp

Vikas27 · Answer

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