Dataflux 2.8 - How to add additional tabs to a excel file output

[beamer108]

I currently have a datajob that writes output to a .xls file. It contains one tab with all the data I need. The business now wants another tab added to the same worksheet that contains some of the columns from the first tab as well as some additional columns.  How do I add another tab to the same worksheet?

[VincentRejany]

Tried with the following configuration and it worked

[beamer108]

Thank you I will give this a try.

[beamer108 · Accepted solution]

This worked great when I ran it on the client machine but when I tried to run it on the server it does not work. I reached out to our admin team and because of our set up our df configuration on the server is not compatible with an excel driver.  Not sure if I captured that correctly but basically I was told due to how we are set up its not an option.  So to resolve the issue I worked with our SAS EG experts and we created the job using SAS code and our customer is receiving the output in the format they needed. Thanks for the advice and guidance.

[RacheLGomez123]

Hold down SHIFT, and then select the same number of existing sheet tabs of the worksheets that you want to insert in the open workbook. For example, if you want to add three new worksheets, select three sheet tabs of existing worksheets. On the Home tab, in the Cells group, click Insert, and then click Insert Sheet.

Regards,
Rachel Gomez

[beamer108]

Thank you Rachael for responding. I actually was looking for within the Dataflux process how to create a worksheet that contains multiple tabs containing data on output.  I found that due to how our admins set up our dataflux the option isn't available on our server so I've found the solution using SAS programming.  Thanks again for responding, but at this time I am all set.