Error: The process cannot access the file because it is being used by another process

[mhlima]

I need help connecting each of the records in Block M, which I'm breaking the txt. I want the outputs to come out in the same Excel, separated by sheets.In this way:

I'm using these respective paths: %User.MAIN_DIR%\Bloco M.xlsx|||M001, %User.MAIN_DIR%\Bloco M.xlsx|||M010, %User.MAIN_DIR%\Bloco M.xlsx|||M030. 

When I put it running the way it is, it gives me this error: "the process cannot access the file because it is being used by another process".Which indicates that the outputs are using the same excel created at the time of the flow run. 

Please, I need help.

[Bren_Spill2]

Is it only dates that you are cleansing? Or are you making other changes? If you can put together some sample data that looks like the data you have that would be helpful 

[Bren_Spill2 · Accepted solution]

@mhlima - if you want to get to a solution quickly - you can set up the block until done tools like this:

Please attach sample data if you can.

[mhlima]

Right, understood. Here is an example:

[mhlima]

I'm trying to test with the lock, but I can't connect output 2 with the output data of the second container.

 

[Bren_Spill2]

You have the block until done in the wrong place. Refer to this screen shot:

[mhlima]

I understood now, it worked! Thank you very much.