File Processing

Extract From XML To Flat Files

May 19, 2014 · Matt Irvin

This tutorial will demonstrate how to extract sample data from an xml file and read each xml record into a separate output file.

Using Multischema Files

January 16, 2014 · Matt Irvin

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.

Iterate To Load Multiple Excel Files

August 22, 2012 · Matt Irvin

This post is an extension of our previous post – 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 excel files into a MS Access database table.

Import An Excel File Into Access

August 18, 2012 · Matt Irvin

Sometimes integrating Talend with Excel data files can be particularly challenging, in this post we are going to walk you through the basic steps required to get started on build a job to load a MS Excel file into an Access database.