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, […]
The tREST component serves as a REST Web service client that sends HTTP requests to a REST Web service provider and gets the responses. This scenario describes a simple Job that invokes a REST Web service to get a user record from GitHub and then retrieve the user information. When executed, the Job displays relevant information on the […]
Talend has various component which will help us to achieve Excel Like Transpose, for that we are going use tDenormalise and tNormalize component. tDenromalize tDenormalize component will help you to Denormalizes the input flow based on one column, Scenario: Process spreadsheet by columns instead of by rows. Our goal is to convert mentioned input to Expected output […]
tFileInputJSON extracts JSON data from a file according to the JSONPath query, then transferring the data to a file, a database table. tFileInputJSON Use Case : This post I will demonstrate you, how to parse JSON File using Talend. Below is our sample JSON File.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
{ "Person": { "firstName": "John", "lastName": "Smith", "age": 25, "Address": { "streetAddress":"21 2nd Street", "city":"New York", "state":"NY", "postalCode":"10021" }, "PhoneNumbers": { "home":"212 555-1234", "fax":"646 555-4567" } } } |
You can download sample file here. Step 1: Click On Json […]
tFileList retrieves a set of files or folders based on a filemask pattern and iterates on each unity. tFileList is the frequent use component which allows you to list down files, from provided directory. This post we will see different use case examples of tFileList. tFileList has following global variable. Global Variables List ((String)globalMap.get("tFileList_1_CURRENT_FILE")) this variable […]