Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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