Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

How to avoid .bak files of output excel files

RAMN
8 - Asteroid

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
15 - Aurora

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
14 - Magnetar
14 - Magnetar

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
7 - Meteor

Hi, 

 

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

 

Regards.

Labels