tFilelist- Latest file from directory

tFileList use case example iterates on files or folders

tFileList retrieves a set of files or folders based on a filemask pattern and iterates on each unity. tFileList is the frequent use component which allows you to list down files, from provided directory. This post we will see different use case examples of tFileList. tFileList has following global variable. Global Variables List ((String)globalMap.get("tFileList_1_CURRENT_FILE")) this variable […]

Create File Name with Incremental Number Output

Create File with Incremental Number on each run of job

This post is based on  below comment from Mahesh who is facing problem, and wanted help from us. Here is the comment for reference.   Hi Umesh, the above post is very useful. Could you please help me out on this ? My requirement is :- The file which gets generated after running etl is “XYZ_20150603_1.csv” […]

Before and After file delete output

Delete files more than N number of days old

Scenario: Delete files more than ‘N’ number of days older, using Talend. Step 1: Create Job and add tFileList on canvas and configure as follows. Set Directory path as your files location. Select FileList Type as “Files”. Case Sensitive=”No”. Add File mask as “*.txt”. ( you can add per your file type). Step 2: Add tFileProperties […]

Get Latest file from folder

How to get latest file from directory

This post I will describe, how to get most resent file from directory based on display date or a date from file name. We have below sample files in our directory and every file has date in the name of file, based on that we will decide which file is most resent rather than file created date/ […]

tFileList Exclude Mask

This post I will describe you how to exclude files using tFileList component. Below are our sample files which stored in folder. From above file list we want to read only files with name starts with “Orders_” and ends with “.csv” therefore we are using tFileList mask to get the file list. Add tFileList component […]