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.

[JosephSerpis]

Hi @mhlima you need to use Block until done tools to stop your output data tools writing to the file at the same time. If you have Alteryx Designer 2023.1 or higher you can use Control Containers to control the sequence. 

[mhlima]

Hello @JosephSerpis, thanks for the reply. However, I need to know how I can do this control by containers or by the blocking tool, can you give me an example? My alteryx is 2022.3

[Bren_Spill]

@mhlima  - without understanding how your data looks to the left of the three containers in your screen shot, you could set up the block until done like in the screen shot below

[Bren_Spill]

@mhlima alternatively, set up your control containers like this (only available in v2023 and above):

[mhlima]

The initial imput is like this, there are several outputs, but I sent as an example only 3. Can I get the solution without having to change versions? thinking in a group, because other colleagues will have the same version I'm using.

[Bren_Spill · Accepted solution]

@mhlima you would need a lot of block until done tools to get this to work given you have so many outputs - it wouldn't be very efficient.

I would recommend using a batch macro. Can you send some sample data?

[mhlima]

@Bren_Spill It is sensitive data, I can't. Can you show me an example of a macro in another way?

[Bren_Spill]

@mhlima before I put an example together - from your screen shot it looks like you're making slightly different changes to the data before writing out each sheet - is that accurate? Or can the changes be standardized for all outputs?

[mhlima]

@bren_spill It is necessary, because in some records I need to treat dates.