Error Outputting multiple files

Hi All,

Wondering if we have solution to output multiple sheets in single file.

I have 40 sheets which need to be placed under single excel file and all sheets have different data structure, getting error message "Unable to make final write <File path> Error in use by another process" while outputting. I tried BlockUntilDone but still facing same issue.

Workflow

Transformation

Accepted answers

AkimasaKajitani

Hi @GayatriPanigrahi ,

Do you run the Workflow in Alteryx Engine? If you use the AMP Engine, please change to the Alteryx Engine(don't use AMP Engine).

It is difficult to use the UBD in AMP Engine.

Or do you try to use Parallel Block Until Done in Crew Macro?

http://www.chaosreignswithin.com/p/macros.html

The last method I can think of is to use a batch macro.

Each data into specific sheet must be Name & Value Fields with Sheet and Record ID field.

After that, you put the data into the Batch macro, you need to recover the data by using Cross Tab tool and save them in the Batch Macro for each sheet.

Batch Macro:

In any case, you can use this macro with a light fix.

Please check the attached workflow.

If you have any question, let me know.

Macro_use_sample.yxzp

All comments

echuong

Are you able to share a sample of your data and/or workflow?

binu_acs

@GayatriPanigrahi

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

atcodedog05

Hi @GayatriPanigrahi

Only possible best way I can think of is by using reporting. Convert all the sheets to tables and output them to each sheets using a single render tool. In this method, each sheet is written one after other in a single tool hence it doesn't create write block,

Why Single Output tool doesn't support this?

Output tool expects you too have same columns for sheets hence doesn't.

How Reporting tools support this?

Since at the end there is only one column that table the actual data column doesn't matter.

Note: one drawback is all sheet will have the same width and there is nothing that can be done.

Hope this helps : )

output multiple sheets.yxmd

AkimasaKajitani

Hi @GayatriPanigrahi ,

Do you run the Workflow in Alteryx Engine? If you use the AMP Engine, please change to the Alteryx Engine(don't use AMP Engine).

It is difficult to use the UBD in AMP Engine.

Or do you try to use Parallel Block Until Done in Crew Macro?

http://www.chaosreignswithin.com/p/macros.html

The last method I can think of is to use a batch macro.

Each data into specific sheet must be Name & Value Fields with Sheet and Record ID field.

After that, you put the data into the Batch macro, you need to recover the data by using Cross Tab tool and save them in the Batch Macro for each sheet.

Batch Macro:

In any case, you can use this macro with a light fix.

Please check the attached workflow.

If you have any question, let me know.

Macro_use_sample.yxzp

GayatriPanigrahi

Hi All,

Thank you for your response.

Unfortunately i can not share entire workflow but workflow look like as attached image which has ~40 output sheet and each sheet has different data structure. And at present can not use external add-on feature with alteryx due to audit.

Just thought is there a way we can create macro which accept multiple input and generate multiple output and inbetween block until is used.

Alteryx_Multiple_Output.PNG

AkimasaKajitani

Hi @GayatriPanigrahi

I think that my macro uploaded at previous post can work well.

Can you download it? Is that also recognized as an external add-on?

Please refer my previous post.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703