August 15, 2023

Sorting entries – Docs for ESB 6.x

Sorting entries

This scenario describes a three-component Job. A tRowGenerator is used to create random entries which are directly sent
to a tSortRow to be ordered following a defined value
entry. In this scenario, we suppose the input flow contains names of salespersons along
with their respective sales and their years of presence in the company. The result of
the sorting operation is displayed on the Run

  • Drop the three components required for this use case: tRowGenerator, tSortRow and
    tLogRow from the Palette to the design workspace.

  • Connect them together using Row
    main links.

  • On the tRowGenerator editor, define the
    values to be randomly used in the Sort component. For more information regarding
    the use of this particular component, see tRowGenerator

  • In this scenario, we want to rank each salesperson according to its
    Sales value and to its number of years in the

  • Double-click tSortRow to display the
    Basic settings tab panel. Set the sort
    priority on the Sales value and as secondary criteria, set the number of years
    in the company.

  • Use the plus button to add the number of rows required. Set the type of
    sorting, in this case, both criteria being integer, the sort is numerical. At
    last, given that the output wanted is a rank classification, set the order as

  • Display the Advanced Settings tab and select
    the Sort on disk check box to modify the
    temporary memory parameters. In the Temp data directory
    field, type the path to the directory where you want to
    store the temporary data. In the Buffer size of external
    field, set the maximum buffer value you want to allocate to
    the processing.


The default buffer value is 1000000 but the more rows and/or columns you
process, the higher the value needs to be to prevent the Job from automatically
stopping. In that event, an “out of memory” error message displays.

  • Make sure you connected this flow to the output component, tLogRow, to display the result in the Job

  • Press F6 to run the Job. The ranking is based
    first on the Sales value and then on the number of years of experience.


Document get from Talend
Thank you for watching.
Notify of
Inline Feedbacks
View all comments
Would love your thoughts, please comment.x