topic Re: Copy files with rename based on query in Talend Studio

Copy files with rename based on query

Anonymous — Mon, 18 Dec 2017 10:06:41 GMT

Hello, I need to copy a bunch of files from a folder to another one and rename them during the process ; and I have a table on my database with the actual files' names and the destination names ; I stated a solution with contexte variable but lost my way ; Desperately need guidance to this, thank you

Re: Copy files with rename based on query

TRF — Mon, 18 Dec 2017 11:02:00 GMT

Hi,

Here is the right direction:

tYourdatabaseInput --> tFlowToIterat --> tFileCopy

Hope this helps.

Re: Copy files with rename based on query

Anonymous — Mon, 18 Dec 2017 11:11:13 GMT

Dear TRF Thank you for your answer ; can you please elaborate this solution ?

Re: Copy files with rename based on query

TRF — Mon, 18 Dec 2017 13:17:11 GMT

If you connect tFlowToIterate to your tDatabaseInput component, you'll get 1 global variable per field.

Assume you have 3 fields (currentFilename, destinationFolder and destinationFilename) and the flow after tDatabaseInput is called "row1".

Here is the tFileCopy configuration :