Tfilterrow to Tftpget

[JFournier1632810800]

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

[Anonymous · Accepted solution]

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

[JFournier1632810800]

Hello Shong,

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