Convert String To Date

This Post I will describe you, how to Convert String to date in Talend. I will use various string dates to demonstrate. Converting simple string with consistent format: “MM/dd/yyyy hh:mm” 12/21/2000 0:00 we will convert above date with “MM/dd/yyyy hh:mm” format. for that we will use below built in function from TalendDate routine. TalendDate.parseDate(“MM/dd/yyyy hh:mm”,”12/21/2000 0:00″) above function […]

Read XML with Optional Elements

This post I will describe how to parse XML with optional element. We will use below source xml file which has three customer details, along with awards details, and <CUSTOMERAWARDS> is a optional xml element. We will parse this file using tXMLMap component. so fist of all add tFileInputXML and configure as below. Assign source […]

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