Extract from XML to Flat Files

This tutorial will demonstrate how to extract sample data from an xml file and read each xml record into a separate output file. The example file we will use is a simple file with the following format: <root> <field1>Test Data 1</field1> <field1>Test Data 2<
Continue Reading →

Using tMemorizeRows to compare Data

In this job, the tMemorizeRows component will be demonstrated so you can use it in your own applications. In this context, we will use it to check individual rows against each other, specifically to check start and end dates of items. The output will be an indicator of any information
Continue Reading →

Information Aggregation

In some jobs, using a tMap to extract just two columns of data isn’t worth the mapping. Especially if there are operations you need to perform on the data. The tAggregateRow component can easily solve this problem, with a wide array of functions to quickly give you the informati
Continue Reading →

MongoDB + JSON Part Two

Continued from Part 1 Part 2: MongoDB → JSON Step 1:  Create a new job Create a separate job from Part 1. We will begin by placing a tMongoDBInput component and connecting it to a tLogRow component. In this job, we are only going to pull one of the three JSON items we loaded into the
Continue Reading →

MongoDB + JSON Part One

One NoSQL database connector included in Talend Open Studio for Big Data is MongoDB, and using it is quite simple. This tutorial will show the functionality of the different components by importing files into MongoDB from a JSON file, and then exporting a JSON file from MongoDB. This
Continue Reading →

Parsing XML Nested Loops

This tutorial will show how simple it is to parse those deeply-nested XML loops and then simplify the data into one row that is much easier to read. The bulk of the job is set up before it is even created, in Talend’s XML metadata creator, but read on to find out how it works. The doc
Continue Reading →

Using MultiSchema Files

Sometimes in file processing, there are cases where there are multiple schemas within the one file. This tutorial explains how to separate out these files in Talend to keep all the items distinct. This tutorial will also use the file demo_ex as an example. Step 1: View The File The fi
Continue Reading →

Uploading data to Salesforce.com

In this tutorial, we’ll be doing a simple upload to a Salesforce environment to let you get a look on how easy Salesforce integration is in Talend. Though Talend has multiple component options in how to perform your Salesforce loads and Transformations, we’ll stick with simply uploadi
Continue Reading →

Combine multiple files into one

This tutorial will outline the steps required to build a Talend job to append multiple csv files of the same format into a single combined master csv file. Sample csv files used in this tutorial can be downloaded from these links: SalesDetails SalesDetails2 SalesDetails3   Lets g
Continue Reading →

Iterate to load multiple excel files

This post is an extension of our previous post here – Import an Excel file into Access . Today we are going to show you how to build on this job in order to iterate upon a group of excel files in a specified file directory, enabling you to automate the bulk loading of multiple e
Continue Reading →