Move files from one folder to a sub folder

Hi everyone,

Can someone help me on how to move previous Excels files from one folder to a sub folder?

Thanks,

Florence

Run Command

Accepted answers

All comments

Please modify to suit your specific requirement

0305-fjlorenzo.yxmd

Hi @Qiu thank you for your suggestion. I tried it but it's not working. I'm trying to move I:\fjlorenzo to I:\fjlorenzo\previous files.

@Qiu my actual objective is this, I want to compare the latest downloaded file with the most previous file.

Day 1, I want to download a file on a daily basis and add the current date to the filename
Day 2, download the latest file again and add the current date to the filename
Compare the two files - this works because I only have two files
Day 3, download the latest file and add the current date to the filename
Now, how can I compare the latest file from Day 3 with the previous file from Day 2 because I already have 3 existing files?
Day 4, download the latest file and add the current date. How can I compare Day 4 file with Day 3 file?

Thank you for your help.

@fjlorenzo
I assume you mean you are working on a network drive?

I think that will be the limitation of Command Line itself.

Hi @Qiu,

I've an excel file saved at - C:\Users\Public\Testing\1

I want to move it to - C:\Users\Public\Testing\2

I was trying to run your attached workflow. However, I am getting below error.

Error: Run Command (2): The external program "%temp%\RunCommand.bat" returned an error code: 1

Could you please help me figure out, what I am doing wrong?

I even tried using below, still stuck with the same error:

1. move C:\Users\Public\Testing\1\1 Sample.xlsx \C:\Users\Public\Testing\2

2. move C:\Users\Public\Testing\1\1 Sample.xlsx C:\Users\Public\Testing\2

@Lalaiah
The path you are using is not correct. It will change on every time Alteryx flow runs.
Try something like below.

Hi, @fjlorenzo @Lalaiah

If you need move files from folder in Alteryx but don't like create script by yourself , maybe you can use the other 3rd plugin to get .

录制_2022_07_25_09_14_56_95.gif

Could you please add workflow aswel for my reference.

Regards,

Lalaiah

Quick Links

Tags

This months top contributors

Hollingsworth 335