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

Complete Job with tSetGlobalVar setting

Passing value from the parent Job to the child Job

Passing a value from the parent Job to the child Job is a common real world requirement. I am going to describe different ways of passing values from parent job to child job using following different ways. Passing context to child job. Passing globalMap to child and get the result back in parent. Get the […]

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

Page 1 of 212