Multiple Tabs

vijaylnyadav

Hi,

Please consider the following example as a sample data and i have removed the output data due to confidentiality.

Condition:

I have more than 15 files and I want to save the output that that have same column name and type.

I want to save the data in single excel file with different tabs (more than 15).

Error:

I am running the same workflow for say 10 times:

3-4 times it is running successfully and remaining times it is showing the following errors

1. Unable to create a backup file.

2. Access denied.

Please help me on this , as much time i run the workflow it should execute without any error.

It is a sample file if you wish you can create another sample files

Copy of multipletab.yxwz

Datasets

Accepted answers

messi007

@vijaylnyadav,

Strange, are you connected to a sharing folder (One drive that update from local to cloud) if yes please disable it.

Otherwise please try to activate the AMP Engine. I have seen that in this poste that solved the issue: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-Output-Data-39-Unable-to-create-backup-Access-is-denied-5/td-p/615375

Hope that helps!

Regards,

All comments

messi007

@vijaylnyadav,

Have you tried to use a formula in order to create the tabs then generate the file:

Below I have a single file with 10 tabs:

Attached the workflow,

Hope that helps,

Regards,

MultiTabs.yxmd

Qiu

@vijaylnyadav

I had similar experience when exporting more than 150 tabs with similar error.

It seems that something to do with the allocated memory.

Can you try with another PC with larger memory installed?

vijaylnyadav

@Qiu yes i tried in all other possible PCs but sill no progress

vijaylnyadav

@messi007 I am still facing the same error.

Attached is the error image please help me on this because of this my assignment is imcomplete.

MultiTabs.yxmd

error.png

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703