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.
Drop a tSPSSInput component and a tLogRow component from the Palette onto the design workspace.
Right-click on tPSSInput and connect it to tLogRow using a Main Row link.
Click tSPSSInput to display its Basic settings view and define the component properties.
Click the three-dot button next to the Filename field and browse to the SPSS .sav file you want to read.
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.
Click Yes to close the message and proceed to the next step.
If required, click the three-dot button next to Edit schema to view the pre-defined data structure of the source SPSS file.
Click OK to close the dialog box.
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.
To translate the stored values, complete the following:
In the Basic settings view, select the Translate label check box.
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.
Click Yes to close the message and proceed to the next step.
A second message opens up prompting you to accept propagating the changes.
Click Yes to close the message and proceed to the next step.
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.
