Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
JSlatorMHC
Contributor
Contributor

GetFTP when using tSampleRow

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

Labels (2)
1 Reply
Anonymous
Not applicable

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