Skip to main content
Question

Bulk copying particular files from a folder using an Excel list

  • November 6, 2017
  • 1 reply
  • 65 views

Hello, I've tried looking into this and I'm pretty sure I know the readers and writers to use but the middle bit seems to be stumping me.

Put simply, I have a folder with 800 files in it.

I have a list of about 200 files which reside within the aforementioned folder.

I'd like to copy and paste only the files contained within the list into a new folder.

Any help would be greatly appreciated!

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

jdh
Contributor
Forum|alt.badge.img+37
  • Contributor
  • 2002 replies
  • November 6, 2017

Read in the list (excel reader), do whatever manipulation required (attributeRenamer, attributeCreator, etc) to end up with an attribute called filecopy_source_dataset that contains the full path to the file to be copied. Send that to a filecopy writer that has the Destination File Copy Folder parameter set to the new folder.