topic Re: Tfilterrow to Tftpget in Talend Studio

Tfilterrow to Tftpget

JFournier1632810800 — Fri, 15 Nov 2024 22:13:21 GMT

Hello,

I need to upload specific files from a ftp server. Each day I need to check new files and upload it to another location.

So I found how to filter rows to have the list of files and filter its by date but I don't know how to use this list with tFTPGet mask.

Here m'y job

And I use that as file masking : ((String)globalMap.get("row5.basename"))

But it's only return null values.

If any of you got a solution it will be great.

regards

Re: Tfilterrow to Tftpget

Anonymous — Fri, 06 Jan 2023 08:15:13 GMT

I am afraid you need a tUnite component between tFTPFileProperties and tMap_2 to merge all files before filtering them. After you filter the new files, you can store them into memory using tHashOutput, then iterate this list one by one in next subjob.

...tFTPFileList-iterate--tFTPFileProperties--tUnite--tMap--tfilterRow--tHashOutput

****** |onsubjobok

tHashInput--main(row5)--tFlowToIterate--tFTPGet

on tFTPGet, you can set the file masking: ((String)globalMap.get("row5.basename"))

Hope it helps!

Regards

Shong

Re: Tfilterrow to Tftpget

JFournier1632810800 — Fri, 06 Jan 2023 08:54:41 GMT

Hello Shong,

Thanks for your help ! Works pretty well now. Here the final job.