Double-click the tFileInputDelimited
component to display its Basic settings
view.
Click the [...] button next to the
File Name field to browse to your input
file.
Define the header and footer rows. In this use case, the first row of the
input file is the header row.
Click Edit schema to define the schema
for this component. In this use case, the input file has five columns:
Id, FirstName,
LastName, Age, and
City. Then click OK to propagate the schema and close the schema
editor.
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
plus button, select the FirstName and
LastName columns under Schema
column, select alpha as the sorting
type, and select 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 use case,
you will sort out duplicated names.
In the Basic settings view of each of the
tLogRow components, select the
Table option to view the Job execution
result in table mode.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
