Sorting a file in Talend Studio - 7.3

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

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

   Example

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

   Example

   Sort a .csv file according to a defined column
   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 sort a file delimited file with a link to a tSortRow component. The tSortRow component sorts input data based on one or several columns of data, by sort type or order, for example.

1. In the Designer, add a tSortRow component.
2. Right-click the tFileInputDelimited component.
   1. Select Row > Main
   2. Click on the tSortRow component to link the two.
      
3. Double-click the tSortRow component.
4. Click the […] button next to Edit schema.
   
   Because they are linked, the tSortRow component inherits the schema of the tFileInputDelimited component.
5. Click the plus button to add a sorting rule.

   Example

   1. In Schema column, select City.
   2. In sort num or alpha?, select alpha.
      
6. Optional: Click the plus button to add another rule.

   Example

   1. In Schema column, select Street.
   2. In sort num or alpha?, select alpha

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 tSortRow component.
   1. Select Row > Main
   2. Click on the tLogRow component to link the two.