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