Check for Date in Filename in tFileList

Five Stars

Check for Date in Filename in tFileList

Hi , Need some help in talend job. I am using tFileList to process list of files with same structure. i am loading data to table. Need to know how to process these file based on date. I will pass date value as parameter at run time. so if date is satisfied then process else no need to process Example : (4 different files with different 2 dates) C:\Users\stango\source\SrcFolder 20180313file1.txt 20180313file2.txt 20180313file3.txt 20180313file4.txt 20180310file1.txt 20180310file2.txt 20180310file3.txt 20180310file4.txt Please help me how to do this in talend? Thanks

Sixteen Stars

Re: Check for Date in Filename in tFileList

Try using the tFileProperties component. The instructions are here:
Five Stars

Re: Check for Date in Filename in tFileList

use tFileExit and if exist, complete your job else terminate. Identify correct Regular expression  and pass it in file path. Your flow should like below


tFileExist -----> Run If (((Boolean)globalMap.get("tFileExist_1_EXISTS")))  ---- > Rest of the Job


    | Run If !(((Boolean)globalMap.get("tFileExist_1_EXISTS"))) 


tJavaRow (File does not exist)



Venkatanaveen Dasari

Thanks & Regards


Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.