Procedure
-
Double-click tFixedFlowInput to open its
Basic settings view.
-
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.
Click OK to close the schema editor and accept the propagation prompted by the pop-up dialog box.
-
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:
1;Thomas;28;Component Team 2;Harry;32;Doc Team 3;John;26;Component Team 4;Nicolas;27;QA Team 5;George;24;Component Team 6;Peter;30;Doc Team 7;Teddy;23;QA Team 8;James;26;Component Team
-
Double-click tSortRow to open its Basic settings view.
- 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.
-
Double-click the first tLogRow to open its
Basic settings view.
- In the Mode area, select Table (print values in cells of a table) for better readability of the sorting result.