topic Re: How to get latest files from folder based on last run in Talend Studio

How to get latest files from folder based on last run

saivsr — Thu, 24 Aug 2017 05:55:49 GMT

How to get incremental files from same folder …in talend

I have to get files based on last job start date after which are files coming those files i need process..how i can achive this.pls help me..Thank you

Re: How to get latest files from folder based on last run

TRF — Thu, 24 Aug 2017 09:26:59 GMT

Store the last filename processed in a file (and reuse this information for next run) or rename the files after they have been processed.

Re: How to get latest files from folder based on last run

saivsr — Thu, 24 Aug 2017 10:14:44 GMT

Hi TRF, Thanks for your response....My requirement is incremental files are coming to client server from that we need process the those files, which are newly coming from last run..

Ex: Yesterday 10 files came ---> we processed--

today 5 files came ---->total 15(yesterday 10+today 5)--from this i want to get latest files and need to process..

How we can this?

Please share the complete Talend Design ?

Thank you so much

Re: How to get latest files from folder based on last run

Bluemoon — Thu, 24 Aug 2017 19:26:50 GMT

Can you also send your file name format?? I am also facing same issue so,
I came up with a solution where i am getting all in tfilelist and iterate those file from tJava (compare those files and get next file , b4 that i will store last run job file name)
Can anyone give me better solution.. Thanks in Advance!!

Re: How to get latest files from folder based on last run

TRF — Thu, 24 Aug 2017 20:54:38 GMT

The simplest (the better?) is to move (using tfilecopy) the files to a special folder (archive for example) as soon they have been processed. Using this pattern, you don't have to worry about how many files you have processed last day. Just iterate over the filelist and that's all.

Re: How to get latest files from folder based on last run

saivsr — Mon, 25 Sep 2017 12:10:28 GMT

Hi Sir, Thank you for your response..but my client saying without achieve the files we need to process latest files based on last run

Re: How to get latest files from folder based on last run

nmodi — Tue, 03 Oct 2017 15:44:40 GMT

here is how to do that, we had same requirement on getting latest file from FTP,

basically we compare the files creation date & compare it with previous files creation date & that's how we basically sort the file & get latest file,

globalMap.get("sortedmtime") == null ? row1.mtime : (row1.mtime >= (long)globalMap.get("sortedmtime"))?row1.mtime:globalMap.get("sortedmtime")

There are so many other solution out there like using tbuffer to store all files & then use tSort to sort data

Re: How to get latest files from folder based on last run

saivsr — Fri, 06 Oct 2017 11:19:49 GMT

Thanks Nmodi for your valuable solution..is it working for TOS?

I will try and update you.

Thanks

Re: How to get latest files from folder based on last run

lvsiva — Fri, 02 Aug 2019 13:42:35 GMT

Hi All,

we can do with combination of tFileList and tFileExist components.

Let us Assume A1 is the Source.
Create A2 and A3 two other folders.
Iterate A1 folders with tFileList and use tFileExists -A2 directory path and global variable "tFileList_1_CURRENT_FILE to check the files in A2.
After TfileExistsuse condition tFileExist_2_EXISTS then copy the file using tFileCopy to Folder A3.
At end of run make sync between A1 and A2.
After processing new files in A3 archive/delete them
Like this every run new files will be stored in A3.