Alteryx Designer Desktop Discussions

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

Move Files in network drive

JDong
8 - Asteroid

Hi Team,

 

I have a query that retrieves a list of required 50 PDF file paths from a full directory with like 500 pdf files based on a query

 

AlteryxGallop_0-1676644453052.png

 

Now I want to copy the selected files PDF in the list which is available in the "path" which is a network drive path to a different directory within the network drive. Further once the first time the files are copied over, I would like to use the scheduler to check for new files and perform the same action when there are new files. The scheduler would run on a 4 hour schedule to run check and copy over new files with different names. The file names are unique.

 

Can you please help as to how this can be achieved?

 

Thanks!

1 REPLY 1
patrick_digan
17 - Castor
17 - Castor

@JDong You should be able to copy files using blob tools. Here are a few posts to point you in the right direction:

 

@JosephSerpis :

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-copy-a-template-file-for-use-la...

 

@atcodedog05 and @AkimasaKajitani : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Copy-and-Paste-Excel-from-one-folder-t...

 

@messi007 : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Move-files-without-using-Run-Command-t...

 

For your second part about only copying the new files, you could use a directory tool to query both your original path and new path and then join on filenames to see which records still need copied over and which records are already in the new path.

Labels