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.

above function will return […]

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

Split large XML into multiple XML

In this post, I will describe you how to split large XML into several xml. Here is our Sample XML file. ( which is not huge but just a sample) We are expecting three XML files from sample xml hence lets start with metadata creation for this sample file. Once you created metadata then you can […]