How to avoid .bak files of output excel files

[RAMN]

Hi Community,

How to avoid the creation of .xlsx.bak files for the output files in the output folder as I am using 'overwrite sheet' option in output tool.

Thanks,

Prasad

[LordNeilLord]

Hey @RAMN 

I don't think you can as they are an Excel process.

You could include (as part of your workflow) a script that deletes all of the bak files after the workflow has run

[EstherB47]

Hi @RAMN 

You can't avoid them, but you could write a batch file that you run through Alteryx and remove them.

Great discussion on Bak files here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/What-is-bak-file-used-for/m-p/22195

Cheers,

Esther

[jogayon001]

Hi, 

Can someone share the workflow on how to include the script to delete .bak files after workflow has run?

Regards.