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: 
Anonymous
Not applicable

Extract the most recent file from SFTP

Hi everyone.
I am trying to build a job in open studio that extract the most recent file from a SFTP
Example:

global_act_201907031230.xls

global_act_201906031230.xls

global_act_201907031430.xls  

...

I am getting the path and using it to sort the files based on the date, but I have a problem when I use this path in my tFTPGET component.

This is a print screen of my job.

 

 

0683p000009M6F0.jpg0683p000009M69w.jpg0683p000009M6F5.jpg

 

In my Tmap I get the date using a substring and I convert it in a number format, then I get the correct file_path in my TLogRow but the tFTPGet component is not working correctly.

0683p000009M643.jpg

 

TY in advance!

Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi,

 

    The job is saying that its having Null pointer exception at tFTPGet component. I would recommend you to print all the variables used in tFTPGet and see whether you are getting right data. Also do you want to iteratively do the tFTPGet process or are you sure you want to use main flow to connect to tFTPGet?

 

    Please check the details and if the error persists, could you please provide more details for above areas.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂