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
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!
@JDong You should be able to copy files using blob tools. Here are a few posts to point you in the right direction:
@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.