Our next data processing example will look at sorting data. Let's dive straight in:
Create a new job and name it
Sorting
.We will use the currencies data file that we used previously in this example, so from the Repository Metadata drag the currencies delimited file onto the Job Designer. Select
tFileInputDelimited
from the pop-up window.From the Palette, search for
delimited
and drop atFileOutputDelimited
component onto the Job Designer. Now do a search forsort
and drop atSortRow
component between the two delimited components.Right-click on the currencies delimited input and, using Row | Main, connect it to the sort component. Similarly, right-click on the sort component and use Row | Main to connect it to the delimited output component.
In the Criteria box of the
tSortRow
component, click on + to add a row—some default values will be shown. The criteria we enter here will determine how the output is sorted. Let's leave the Schema column value ascountry
, but change the sort...