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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] File Exist FTP

Hi,
Here is my situation. I am having daily a files wich I need to pull out from FTP. Before I have chose my file I need to check did my files already existing in my current folder.
I have to check by time stamp as that is the only way for me as my files will come or come most of time with same name but the only differents are by timestamp .
I am able to pull my files from FTP , I think I am doing correct even to chose them by timestamp ( I am using tAgregateRow, maybe I am not right ) but not sure how to do check before I start to look for my file , how to chose the only new one, and file with not existing in my directory.
if anyone have any idea please let me know.
Thanks
Zeljka
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi
I am able to pull my files from FTP , I think I am doing correct even to chose them by timestamp ( I am using tAgregateRow, maybe I am not right )

Yes, you are in the right way, get the timestamp and it return a long type, choose the max value (that is the newest file) on tAgregateRow component.
About how to judge the file exist already in target folder or not, see
https://community.talend.com/t5/Design-and-Development/TFTPConnection/td-p/83194
Best regards
Shong

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi
I am able to pull my files from FTP , I think I am doing correct even to chose them by timestamp ( I am using tAgregateRow, maybe I am not right )

Yes, you are in the right way, get the timestamp and it return a long type, choose the max value (that is the newest file) on tAgregateRow component.
About how to judge the file exist already in target folder or not, see
https://community.talend.com/t5/Design-and-Development/TFTPConnection/td-p/83194
Best regards
Shong
Anonymous
Not applicable
Author

Thanks Shong