Delete Files

[#1]

This macro uses python and os library to delete any given filepaths.

It is a good way to delete for example the *.bak files.

INPUT of filepaths to be deleted (example):

FilePath

C:\...\Output.xlsx

C:\...\SAPExtraction.txt

C:\...\Report.pdf

[ksalo1]

Works very well, and simple to set up.

[sammyb84]

Hey @Felipe_Ribeir0 , I downloaded and followed steps but I must be missing something.

Am I supposed to put file path that I want to target in all inputs in both the MC_Removefiles and Removefiles workflow where it says path and directory?

MC_removefiles workflowRemovefiles workflowMC_removefiles workflow

[Felipe_Ribeir0]

Hi @sammyb84 

You dont need to change anything inside of the macro, just provide the fullpath of the file to be deleted to the macro as input.

Maybe taking a look at these videos can help you to understand how it works:

Advanced Certification Learning Path - Alteryx Community

[sammyb84]

Hi @Felipe_Ribeir0 ,

I did provide fullpath of the file to be deleted, but which workflow am I inserting it into.  I provided screenshots showing where I inserted the full path but it still not working.

[hafiznaim]

Hi Felipe,

I'm trying to use the macro you provided and to delete the file only have no data.

My data sample are:

DistributorCode	ItemCode	ItemDesc	ErrorMessage	ProcessTimestamp
A#	1101324002	NEXU  25KG	Missing Item Code in Table Product Mapping	6/27/2024 11:42
A#	1101324002	NEXU  25KG	Missing Item Code in Table Product Mapping	6/27/2024 11:42

DistributorCode,ItemCode,ItemDesc... are my column 

if data exist the flow will run to downstream(other tool, file not deleted),

if no data(having column only consider as no data), the file will be deleted:

I adjust the Jupyter notebook:

//// end code

Then, at the filepaths Input)inside REMOVEDFILES. yxmd i put full path to my excel file( path....\excel.xlsx)

So how can i achieve this