topic Re: Import tFileInputDelimited and pass column values to tFtpGet as file mask? in Talend Studio

Import tFileInputDelimited and pass column values to tFtpGet as file mask?

Anonymous — Wed, 20 Nov 2019 18:50:48 GMT

Hi everyone,

I tried a few things without success.

Basically I just want to feed a list of files to an tFtpGet component. I have a singular column of file names within a tFileInputDelimited component and run through the list, passing each file name to a file name mask within an tFtpGet component.

tFileInputDelimited -> fFlowToIterate -> tFtpGet

I know this isn't right but the farthest I get is a null pointed exception on the first row processing but when I disable the FTP component and put the output to a tLogRow it displays all the file names as expected.

Can you please point me in the right direction?

Thanks

Re: Import tFileInputDelimited and pass column values to tFtpGet as file mask?

TRF — Wed, 20 Nov 2019 20:15:49 GMT

This is the right direction.
If the row between tFileInputDelimited and fFlowToIterate is named row1 and fFlowToIterate has the default settings, you should be able to use (String)globalMap.get("row1.filename") for the filemask field.
Feel free to share your settings.

Re: Import tFileInputDelimited and pass column values to tFtpGet as file mask?

Anonymous — Wed, 20 Nov 2019 21:10:45 GMT

Thanks! That is what I needed.

Is it possible to set a wildcard in the remote directory input? I want to set a directory but let it go through all sub-directories to scan for a given file.

Remote directory: "folder name/./"

This is what I tried, hoping "." would trigger a wildcard for the sub-directories but it doesn't seem to be taking it. I don't see an option to explicitly include sub-directories.

Thanks!

Re: Import tFileInputDelimited and pass column values to tFtpGet as file mask?

TRF — Wed, 20 Nov 2019 21:25:28 GMT

Not sure. You have to try it by yourself.