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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
JSey
Creator
Creator

Need help with what to do with previous input files in case of script failure.

Hi everyone

 

I have a Talend script that will retrieve the latest csv files from a sftp server (let's say filename abc-mmDDYYYY with mmDDYYYY being the date). I have a tfilelist to use a mask based on the file names and to sort the files by modified date desc. I need feedback on best practices after this part:

 

1) Assuming the files are sent to the sFTP daily, if the script doesn't run for 2 days, it will have 2 set of files. How can it process both set of files? I did a test by making a copy of one file and the script only processed one set of file.

 

0693p00000AbgNhAAJ.jpg 

2) Would it be best practice to move the script to a processed folder on the sftp (or your suggestion)?

 

Thank you for your help everyone

Labels (3)
1 Reply
JSey
Creator
Creator
Author

Any help would be appreciated, thanks.