How to remove excel files in folders with Alteryx

[Maugi]

Hello,

I'm very new with Alteryx and I do not had training for it.

I would like to know how can we move some excel files located in folder to another folder with Alteryx.

I have 11 excel files per month created with my Alteryx flow in one folder and I want to move them once we are in the next month to make place to the 11 new ones.

Today, I move the 11 excel files to another folder manually and I would like to make this operation automatic.

Thanks a lot for your help !

[binuacs]

@Maugi  https://tarsolutions.co.uk/blog/move-or-copy-files-in-alteryx/

[csmith11]

Go here:

https://gallery.alteryx.com/#!app/File-Operations/5f4016520462d715e4d43e97

Click on the GitHub Link

https://github.com/bobpeers/Alteryx_SDK_FileCopyMove

Download and Install the .yxi file.

This tool is super simple to deploy if you organization will let you install this Macro.

Otherwise the Run Command Approach is great as well.

[csmith11]

Once you've download the tool its super simple to deploy:

The workflow I'm sharing won't may not work until that .yxi file is installed. But here a simple example to move files from one folder to the next.

[Maugi]

Hello @binuacs

Thanks for your answer, I tried several times and I still cannot move my "test_file.xlsx"

You can see below what I did.

did I do something wrong ?

I didn't understand the command tool part.

Thanks again for your help

[Maugi]

Hello csmth11,

Thanks a lot for your answer, I also tried with this "file Copy and Move" but actually I don't understand how it works.

Know that I never used Alteryx before.

Can you please tell me a bit more about this command ? It seems everyone I very happy to used it.

thanks a lot for your help

[csmith11]

Here's a dynamic Example using the run Tool. Let me know if you are able to get this working on your end.

Pay close attention to the run.bat config.

[csmith11]

Just change copy to move instead