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 […]

Final Job Design

How to Add Header and Footer to a File

I will demonstrate you, how to add custom header, footer to file. This is the often required functionality for file processing and validation. Requirement: Create delimited file with below structure. Header Part File Name: Name of the actual File. PID : process ID. Header Columns. Body Part Text Data.  Footer Part File Created Date: Date […]

tRowGenerator setting

Generate sample data in Talend

This post we will generate sample data for further utilisation.  In ETL world, if you want to test some components you must need data, but getting a desire sample data is very difficult. To generate sample data we will use tRowGenerator component which has built in editor where you can select functions or write your won […]

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/ […]

Difference between tJava,tJavarow,tJavaflex

I have listed down some of the common differences between tJava, tJavaRow and tJavaFlex component.   Operations tJava tJavaRow tJavaFlex Use component to integrate your custom Java code Yes Yes Yes It will be executed first but only once in the subjob. Yes No – It requires Input Flow No Yes No It Requires Output Flow […]