How to remove excel files in folders with Alteryx

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 !

Workflow

Preparation

Accepted answers

All comments

binu_acs

@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.

MoveFiles.yxmd

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

1.PNG

2.PNG

3.PNG

4.PNG

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703