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?
Solved! Go to 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.
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)
}
}
Hi @IraWatt
Another option is to use this macro to delete *.bak files. I found some people using it to do it.