Procedure
-
Double-click the tFileInputDelimited
component to display its Basic settings
view.
- Click the [...] button next to the File Name/Stream field to browse to your input file.
-
Define the header and footer rows.
In this example, the first row of the input file is the header row.
-
Click Edit schema to define
the schema for this component.
- Click the [+] button to add columns. In this example, the input file has five columns: Id, FirstName, LastName, Age, and City.
- Click OK.
-
Double-click the tSortRow component to
display its Basic settings view.
-
To rearrange the entries in the alphabetic order of the names, add
two rows in the Criteria table by clicking the
[+] button:
- Select the FirstName and LastName columns under Schema column.
- Select alpha as the sorting type.
- Select asc the sorting order.
-
Double-click the tUniqRow component to
display its Basic settings view.
-
In the Unique key area,
select the columns on which you want deduplication to be carried out.
In this example, you will sort out duplicated names.
- In the Basic settings view of the tLogRow components, select the Table option to view the Job execution result in table mode.