OUTPUT TOOL

[Gratus_tz]

Hi Everyone

So i have a Data that I have put 9 Filter Tools each filters a certain Testing eg Weekend Transactions, Holidays Transactions extra and i would like to have an Excel Worksheet Data Comprises the Sheets of each Filters where as for now i have Successful Connect each Filter Tools with the Output tool configuring the Path for each Output tools with their names of the Sheets after the Worksheet name separating the Sheets with |||.

But i still get the Errors as only two Output tools functions and the other 7 Bring the Errors. What should I do to gt all the Sheets

[mtryba]

What is the error you are getting on the output tools?  Make sure that all of the output tools are set to "Overwrite sheet or range".  

I've had luck with turning the amp engine off while trying to write to multiple sheets. 

[alexnajm]

Are you using control containers? Control Containers: Take Control of Your Workflow - Alteryx Community

[Gratus_tz]

No am not using Control Containers. Should I use Control Container

[Gratus_tz]

So this is the Rerror that am Getting

Output Data (384) Can't open file:UsersRedirectedFolders\dgekondo\Desktop\JV TEST REPORT.xlsx: The process cannot access the file because it is being used by another process. (32)

 and Yes I have tried to Configure all of the Output tools as Overwrite sheet or Range but still gets the same Error

[alexnajm]

Without seeing your workflow I’m just guessing, but yes likely the control containers will solve it. Check out the use case in the link above