Error "Unable to make the final write to output"

Hi, i am preparing a workflow which will give me around 50 outputs from a single file. I am using a network of "Block until done" tool but still i am getting an error saying "unable to make final write to output". This error is intermittent and is not specific to an output.

Is there any solution to this? I want to extract around 50 outputs in a single run.

Thanks

Workflow

Datasets

Reporting

Transformation

Documentation

Accepted answers

DawnDuong

Hi @AryanJ8881

It could be due to how you configure the output. A file that is in use (eg a Tableau hyper thar is open, or a text file that is opened or an excel that is being written on) cannot be written over.

would you be able to share how you want to extract / output the data?

if you need to write multiple tabs to the same excel or appending data repeatedly, one way is to use the “Block Until Done” or use a batch macro.

dawn

T_Willins

Hi @AryanJ8881,

Block Until Done tools can be tricky to correctly configure. If all the data being output is using the same fields then another option is adding the sheet names as a field in the workflow and using the Change File/Table Name option in the Output Data tool. Alteryx will write the data to the correct worksheets while avoiding this type of error. This can also be used in combination with the Block Until Done if you have a limited number of output formats. Let me know if this may work for you and I can provide additional assistance.

All comments

mceleavey

Hi @AryanJ8881 ,

Block until done only works downstream of that tool, and with 50 outputs, if you are writing to the same source, you are likely to run into this error if you are still writing to the source when you attempt to run another.

You can get around this by putting your output into a batch macro, then feeding the full path (including sheet if you're writing to the dreaded Excel) into the macro as the control parameter. This is a batch macro that will then loop through and write each one individually.

DawnDuong

Hi @AryanJ8881

It could be due to how you configure the output. A file that is in use (eg a Tableau hyper thar is open, or a text file that is opened or an excel that is being written on) cannot be written over.

would you be able to share how you want to extract / output the data?

if you need to write multiple tabs to the same excel or appending data repeatedly, one way is to use the “Block Until Done” or use a batch macro.

dawn

T_Willins

Hi @AryanJ8881,

AryanJ8881

Hi, thanks for the above solutions! I actually used a network/multiple level combinations of block until done tools to move the workflow in a specific sequence to write the output and saved the workflow in "C" drive of my computer. Now this error is gone. I think it was primarily due to less memory space in my laptop.

DawnDuong

Glad to know the errors are gone! Cheers.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703