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
tFileInputDelimitedfrom the pop-up window.From the Palette, search for
delimitedand drop atFileOutputDelimitedcomponent onto the Job Designer. Now do a search forsortand drop atSortRowcomponent 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
tSortRowcomponent, 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...