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 will return […]
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 […]
tMap is frequently used component for joins and lookup purpose, it is also use for verity of operations and transformations, whereas tJoin is used for join and lookups only. tMap tJoin It accepts more than one input one is main and rests of the lookups. It accepts only two inputs and only one is main […]
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 […]
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 […]