Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Move files from one folder to a sub folder

fjlorenzo
8 - Asteroid

Hi everyone, 

 

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

 

Thanks,

Florence

26 REPLIES 26
Qiu
20 - Arcturus
20 - Arcturus

@fjlorenzo 

Please modify to suit your specific requirement

0305-fjlorenzo.PNG

fjlorenzo
8 - Asteroid

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.

fjlorenzo
8 - Asteroid

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

Qiu
20 - Arcturus
20 - Arcturus

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

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

Qiu
20 - Arcturus
20 - Arcturus

@fjlorenzo 

So basically you want the input file from today and yesterday?

I think we can do a Dynamic Input then filter by Date looking for the Today and Today-1.

What do you think?

fjlorenzo
8 - Asteroid

Yes @Qiu that's what I'm looking for. Can you help me with that?

Qiu
20 - Arcturus
20 - Arcturus

@fjlorenzo 
Lets see if this works for you.

0306-fjlorenzo.PNG

fjlorenzo
8 - Asteroid

@Qiu I'm having problems importing your workflow. This error message is showing up.

 

fjlorenzo_0-1614983763586.png

 

Qiu
20 - Arcturus
20 - Arcturus

@fjlorenzo 
Is it possible for you to upgrade to the latest version 2021.1.3?

Labels