Create one excel output from multiple excel files

vicky00750

Hi All,

I am looking to create one file with different tabs.

I have created the workflow as attached. I am splitting the files to multiple excel files.

Along with this i need one more tab, which would come from "ZBA breaks" input and gets split based on a particular field name. This i need to write onto the multiple excel file output in different tab.

Currently I am getting tow excel files as output. I need two different tabs in one excel file.

Can anyone please provide solution to this?

ZBA IM.yxmd

DataNath

Try using a 'Block Until Done' tool (Developer tools), or a 'Parallel Block Until Done' (Will need to download from CReW Macros) and blocking one of the streams until the previous has completed. Also make sure to change the name of one of your outputs so they're not both Sheet1.