topic Need to pick latest file from specific file format. in Talend Studio

Need to pick latest file from specific file format.

Anonymous — Wed, 08 Mar 2017 12:31:48 GMT

Hello Talend Helpers,

May you please help me for getting the current file from directory. Lets see the scenario

In Directory we have below files.

ACBACKLOG2017QTR1-RUNDT-FEB152017.txt
ACBACKLOG2016QTR4-RUNDT-FEB252017.txt
ACBACKLOG2016QTR3-RUNDT-FEB252017.txt
ACBACKLOG2016QTR2-RUNDT-FEB182017.txt
ACBACKLOG2016QTR1-RUNDT-FEB182017.txt

We need to create a logic to pic only current file. Here we have ACBACKLOG2017QTR1-RUNDT-FEB152017.txt as latest file, because its having latest 2017 QTR 1 data.

Also need to make sure that we have already processed previous file before picking the latest one.

Thanks
GopsK

Re: Need to pick latest file from specific file format.

Anonymous — Thu, 09 Mar 2017 08:19:56 GMT

Hi,
Here is a TalendHelpCenter:tFileList component which retrieves a set of files or folders based on a filemask pattern and iterates on each unity.
You can choose to prioritise the folder and file order either by using "Order" option.
Best regards
Sabrina

Re: Need to pick latest file from specific file format.

vapukov — Thu, 09 Mar 2017 10:32:02 GMT

Simplest logic:
[list=*]

process file

move processed file to archive folder (or rename it, or delete)

More intelectual - construct file name pattern for input component
Like:

"ACBACKLOG"+TalendDate.formatDate("yyyy",TalendDate.getCurrentDate())+"QTR"+((Integer.valueOf(TalendDate.formatDate("MM",TalendDate.getCurrentDate()))-1)/3+1)+"*.txt"