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

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.

Error Message

Accepted answers

Bren_Spill2

@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?

Bren_Spill2

@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.

All comments

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_Spill2

@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_Spill2

@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_Spill2

@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_SpillIt is sensitive data, I can't. Can you show me an example of a macro in another way?

Bren_Spill2

@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.

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