Delete all excel files in a folder before processing the rest of the workflow

Question

Hello I have a folder with csv files and excel files. I need to delete all the excel files in the folder as a step in my workflow, can you please let me know how I can do this?

Thank you so much!

dbowins · Answer

I live in the command tool. Mainly SFTP delivery and file moves. Recently, running extremely large python api scripts. That was a real doozy, but Alteryx got it done.

mst3k · Answer

I always found the Run command tool very difficult to understand at first, and then it made sense. Til I need to set it up from scratch again down the road and figure it out again.

But you can do great things with it, especially as far as creating folders, moving or deleting files, etc.

I made a macro tool to delete the automatically created .BAK files that Alteryx creates, particularly useful when your output is multiple worksheets into an Excel file - your report folder will have a .BAK file for each Excel file that gets created. Plop the macro into your workflow and it'll delete any .BAKs each time it runs

Qiu · Answer

@Holidayday

Attached is a sample and please modify the path to your need.

0324-Holidayday.yxmd