tDenormalize source and expected output

Excel Like Transpose using Talend

Talend has various component which will help us to achieve Excel Like Transpose, for that we are going use tDenormalise and tNormalize component. tDenromalize tDenormalize component will help you to Denormalizes the input flow based on one column, Scenario:  Process spreadsheet by columns instead of by rows. Our goal is to convert mentioned input to Expected output […]

tFileInputJSON Use Case-Parse JSON using Talend

tFileInputJSON extracts JSON data from a file according to the JSONPath query, then transferring the data to a file, a database table. tFileInputJSON  Use Case : This post I will demonstrate you, how to parse JSON File using Talend.  Below is our sample JSON File. { “Person”: { “firstName”: “John”, “lastName”: “Smith”, “age”: 25, “Address”: { “streetAddress”:”21 […]

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

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