How to stop Alteryx producing .bak files when outputting to Excel

[IraWatt]

When I output to excel I always have an accompanying .bak file is there anyway to turn off the auto output of .bak files, they clog up my directories?

[IraWatt · Accepted solution]

Found a work around on Make backup (bak) file creation optional - Alteryx Community, you don't seem to be able to stop this feature. 

[jeneir]

I use R code for file and folder action.

OutputPath is full path of the Excel file.

message("************ Delete BAK ************")

library(readr)

df <- read.Alteryx("#1", mode="data.frame")

message(paste("Number of files: ", nrow(df)))

if (nrow(df) > 0){
for (i in 1:nrow(df)){
deleteMe <- paste(df[i, 'OutputPath'], ".bak", sep="")
if (file.exists(deleteMe))
message(paste("Deleting: ", deleteMe))
file.remove(deleteMe)
}
}

[Felipe_Ribeir0]

Hi @IraWatt 

Another option is to use this macro to delete *.bak files. I found some people using it to do it.

Delete Files - Alteryx Community

[Dhrish]

-