multiple if-then-else Statement in Talend with Result

If-Then-Else statement in Talend

If-Then-Else is the common requirement of Talend implementation to use conditional execution of job, component or data, during various part of Talend job development. Following are the possible ways of implementing If-Then-Else cases. Using tMap: If Then Else with tMap AS you know tMap is versatile component which allows us developing lookups, rejects, conditional formatting, transformation, data filter, […]

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

Validate CSV headers in Talend.

File processing is a day to day task in ETL world, and there is huge need of validation regarding source file format, headers, footers, column name, data type and so on, thanks to tSchemaComplianceCheck component which can do most of the validation like. Length checking. Date pattern/format. Data Types But does not support number of […]

Split Rows to Columns

This post I will describe you how to split rows into columns, we will use below sample as input records. Input Rows. Expected Output. Create a Job and add tFixedFlowInput component and  put above input as “Use inline content” and create schema as shown in image. Add tPivotToColumnsDelimited  component and connect with tFixedFlowInput component as main connection then configured this component […]