How to delete .xlsx.bak files

[Naga]

Hello,

I need some help in in removing / deleting the .xlsx.bak files, which I get as an ad-hoc when I ran the WF. I have to run around 200 files and creating this .xlsx.bak is redundant.

Thanks

Naga

[Rahul_Analyst · Accepted solution]

Hi @Naga,

This post should help you.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-avoid-bak-files-of-output-excel...

[allwynthomas24 · Accepted solution]

Just create a text file and type the code given below - 

del "YOUR FOLDER FULLPATH\*.xlsx.bak"

Save this file with the windows batch file extension (.bat)
eg: bakFileDelete.bat

You can now double click on this .bat file to delete the .bak files after your Alteryx Workflow has been executed OR you can use RUN COMMAND TOOL in your Alteryx Workflow itself and configure the tool to run the above mentioned .bat file automatically. 
Link to RUN COMMAND TOOL in Alteryx Documentation - https://help.alteryx.com/20214/designer/run-command-tool

[Alteryx_AR · Accepted solution]

Hey @Naga , Just give a look here - What is bak file used for? - Alteryx Community 

Hope this helps ....Thanks:)

[allwynthomas24]

Hey @Naga,

Thanks for accepting the solution.

Regards,

Allwyn

[Alteryx_AR]

Hey @Naga  Thanks for accepting as a solution .

[knobsdog]

I have this issue with bak files on a SharePoint site.  What would the pathway be like to have it go into the SharePoint site to delete the bak files in there?