Delete zip files

[wolfgangh]

Hi all,

my workflow is downloading zip files and pulling the data in Alteryx databases. Is there a way to delete the Zip files after the databases are filled?

Thanks and best regards,

Wolfgang

[fmvizcaino]

Hi @wolfgangh ,

Yes, there is a way!

Take a look at this link https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Run-Command/ta-p/31548 

It teaches you how to use run command to various things, you of each, exactly what you want.

"Using batch files/commands (Introduction, Part 1, Part 2, Part 3 - these files/scripts are often used to move/delete/zip files and folders or interact with FTP)"

Best,

Fernando Vizcaino

[wolfgangh]

This is a really good idea. The only issue I can not come across is on how to get a relative path in the batch file.The user is unpacking the workflow package in any folder, so how do I get the destination directory into my batch file?

[fmvizcaino]

Hi @wolfgangh ,

You could use the workflow directory constant to build your batch file.

Best,

Fernando Vizcaino

[wolfgangh]

That is the right way to go. I will use an interface tool to update the value.

Do you have an idea, how I can get workflow directory with the expression editor written out?

I can not get it to work

[fmvizcaino]

Hi @wolfgangh ,

Would you be able to show your idea, as I'm thinking, you don't need to use a action tool, but maybe I'm not seeing the whole picture.

Best,

FErnando Vizcaino

[wolfgangh]

I basically need the workflow directory in the text input, so that I can update the link in the batch file. Thanks for your help

[fmvizcaino · Accepted solution]

@wolfgangh ,

I think it is better to use the constant in a formula tool. One idea is for you to include it in the string you are building inside your formula tool. Another one is to use a replace function where you change something for the workflow directory constant.

Did that make sense?

Best,

Fernando Vizcaino