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?
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.
Delete Files - Alteryx Community
-
2026 and still same 😤
.bak files are a really important part of ensuring you don't lose work or files to corruption, etc. But as many have pointed out, there are simple work-arounds to handle them. I use the output location (filepath) and create a simple delete code that gets sent to the run-command tool to delete them. -Jay
