August 15, 2023

Sorting the input data – Docs for ESB 6.x

Sorting the input data

  1. Double-click tFixedFlowInput to open its
    Basic settings view.

    components-taggregatesortedrow_s1_tfixedflowinput.png

  2. Click the […] button next to Edit schema and in the pop-up window define the
    schema by adding four columns: Id and
    Age of Integer type, and Name and Team of
    String type.

    components-taggregatesortedrow_s1_tfixedflowinput_schema.png

    Click OK to close the schema editor and
    accept the propagation prompted by the pop-up dialog box.
  3. In the Mode area, select Use Inline Content(delimited file), and then in the
    Content field displayed, enter the input
    data to be sorted and aggregated. In this example, the input data is as
    follows:

  4. Double-click tSortRow to open its Basic settings view.

    components-taggregatesortedrow_s1_tsortrow.png

  5. Click the [+] button below the Criteria table to add as many rows as required and
    then specify the sorting criteria in the table. In this example, two rows are
    added, and the input entries will be sorted based on the column Team and then the column Age, both in ascending order.
  6. Double-click the first tLogRow to open its
    Basic settings view.

    components-taggregatesortedrow_s1_tlogrow1.png

  7. In the Mode area, select Table (print values in cells of a table) for better
    readability of the sorting result.

Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x