Question

Bulk copying particular files from a folder using an Excel list

  • 6 November 2017
  • 1 reply
  • 26 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!


1 reply

Badge +22

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.

Reply