GetFTP when using tSampleRow

[JSlatorMHC]

Hi All,

I am quite new to talend so this might be a easy question!

The aim of my job is to retrieve files that have been added to the FTP server that day.

I am retrieving files from a FTP server each day. The files arent removed from the FTP server after download so i have built a job to extract the date from the file name (the file name is name_type_data_sync_yyyymmdd.csv) the sort on month day. I have used tsamplerow to get row 1. I have added tlogrow and when i run my job i get the the latest filename and filepath.

The issue i now have is i am not sure how i link this to ftpGet i have tried added the ftpGet component but get errors.

Any help appreciated

[Anonymous]

Hi

Store the file name to context variable for used later on tFTPGet, eg.

....tSammeRow--tJavaRow

|onsubjobok

tFTPGet

on tJavaRow:

context.filename=input_row.ColumnName;

Hope it helps you!

Regards

Shong