Scenario: Displaying the content of an SPSS .sav file - 6.1

Talend Components Reference Guide

EnrichVersion
6.1
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

The following scenario creates a two-component Job, which aims at reading each row of a .sav file and displaying the output on the log console.

Setting up the Job

  1. Drop a tSPSSInput component and a tLogRow component from the Palette onto the design workspace.

  2. Right-click on tPSSInput and connect it to tLogRow using a Main Row link.

Configuring the input component

  1. Click tSPSSInput to display its Basic settings view and define the component properties.

  2. Click the three-dot button next to the Filename field and browse to the SPSS .sav file you want to read.

  3. Click the three-dot button next to Sync schema. A message opens up prompting you to accept retrieving the schema from the defined SPSS file.

  4. Click Yes to close the message and proceed to the next step.

  5. If required, click the three-dot button next to Edit schema to view the pre-defined data structure of the source SPSS file.

  6. Click OK to close the dialog box.

Job execution

Save the Job and press F6 to execute it.

The SPSS file is read row by row and the extracted fields are displayed on the log console.

Translating the stored values

To translate the stored values, complete the following:

  1. In the Basic settings view, select the Translate label check box.

  2. Click Sync Schema a second time to retrieve the schema after translation.

    A message opens up prompting you to accept retrieving the schema from the defined SPSS file.

  3. Click Yes to close the message and proceed to the next step.

    A second message opens up prompting you to accept propagating the changes.

  4. Click Yes to close the message and proceed to the next step.

  5. Save the Job and press F6 to execute it.

The SPSS file is read row by row and the extracted fields are displayed on the log console after translating the stored values.