Reading a file in Talend Studio - 8.0

Creating a project is the first step to using Talend Studio. Projects allow you to better organize your work.

1. Select Create a new project.
2. Enter a name for your project.

   Example

   TalendDemo
3. Click Create.
4. Click Finish.

Talend Studio projects contain Jobs. In Jobs, you can build workflows through components, which allow you to complete specific actions.

1. In Repository, right-click Job Designs.
   1. Click Create Standard Job.
2. In the Name field, enter a name.

   Example

   readCSV
3. Optional: In the Purpose field, enter a purpose.

   Example

   Read a .csv file
4. Optional: In the Description field, enter a description.

   Example

   This tutorial uses a component to read a .csv file
   Tip: Enter a Purpose and Description to stay organized.
5. Click Finish.

Talend Studio components allow you to complete specific actions. You can add them to Jobs. You can use the tFileInputDelimited component to read a delimited file, for example.

Before you begin

This tutorial makes use of a .csv file. If you do not have a .csv file, click the Downloads tab and save customers_unordered.csv.

1. Click inside the Designer.
2. Enter tFileInputDelimited and select the component of the same name.
3. In the Designer, double-click the tFileInputDelimited component.
   1. Click the […] button next to the File Name/Stream field.
      
   2. Select the file of your choice in the File Explorer.
   3. Optional: Check your file's Field Separator and change it, if needed.
      Note: The most common Field Separator is ;

Defining the component schema of your delimited file helps you parse the data you are working with.

1. In the Designer, double-click the tFileInputDelimited component.
2. Click the […] button next to Edit schema.
   
   The Schema wizard opens.
3. Click the plus button to add a Column.
   1. Add as many columns as there are headers in your .csv file.
      Note: Headers are the first values in a .csv file.

      
   2. Enter the name of each Column.
      Column names must be identical to header names.

      Example

      • First
      • Last
      • Number
      • Street
      • City
      • State
   3. Select the Type of each Column.
      Tip: Select the String Type for a postcode. A postcode number does not serve an arithmetic function.
4. Click OK.

You can display the result of a workflow with a link to a tLogRow component. The tLogRow component displays data in the Run console.

1. In the Designer, add a tLogRow component.
2. Right-click the tFileInputDelimited component.
   1. Select Row > Main
   2. Click on the tLogRow component to link the two.
      
3. In the Run view, click Run.