Attention: The Alteryx-supported tab in the Community Gallery will soon be archived. You will still be able to find supported Add-Ons on the Alteryx Marketplace, and all others on the Alteryx-Built tab.

Community Gallery

Create, download, and share user-built tools and workflows.
Looking for Alteryx built Add-Ons?

Easily shop verified, supported, and secure Partner and Alteryx built Add-Ons on Marketplace.

LEARN MORE
Comments
Clem_cms
5 - Atom

Thanks a lot ! This allows me to delete the .bak files  👍

WorleyT
5 - Atom

Would it be possible for you to show how you do the process inside of Alteryx with a screenshot ? I am unable to update to a newer version and therefor cannot use this workflow. Thanks for any help you can provide.

Felipe_Ribeir0
16 - Nebula

Hi @WorleyT 

 

Download the workflow, and instead of trying to open it, extract it.

 

Felipe_Ribeir0_0-1675255189684.png

 

Then go to the macro, open it and save it again.

 

Felipe_Ribeir0_1-1675255233354.png

 

Then come back to the main workflow

Felipe_Ribeir0_2-1675255268519.png

 

dineshbabu2811
8 - Asteroid

Hi Feli

 

When I try to run the workflow, I'm getting the below error

 

 

Capture.JPG

Felipe_Ribeir0
16 - Nebula

Hi @dineshbabu2811 

 

1-Inside of your python tool, change the kernel for the one available for you

 

2-restart the kernel

 

restart.png

dineshbabu2811
8 - Asteroid

Now I'm getting the permission issue error, what would be the reason any idea

 

Capture_1.JPG

 

Felipe_Ribeir0
16 - Nebula

@dineshbabu2811 after saving the macro with the correct kernel, go to the main workflow and be sure to provide valid filepaths to it, and be sure that the user that is running the workflow have the permissions to do it.

ksalo1
5 - Atom

Works very well, and simple to set up.

sammyb84
8 - Asteroid

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?

 

 
 

snippet of macro.PNG

 

MC_removefiles workflowMC_removefiles workflowRemovefiles workflowRemovefiles workflowMC_removefiles workflowMC_removefiles workflow

Felipe_Ribeir0
16 - Nebula

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
8 - Asteroid

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
5 - Atom

Hi Felipe,

 

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

 

My data sample are:

 
DistributorCodeItemCodeItemDescErrorMessageProcessTimestamp
A#1101324002NEXU  25KGMissing Item Code in Table Product Mapping6/27/2024 11:42
A#1101324002NEXU  25KGMissing Item Code in Table Product Mapping6/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:

test2.png

//// 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

timol87
5 - Atom

excellent thanks. Now that the BAK doesn't self delete half as much as it used to.