Sorting loop elements - 7.3

Talend Data Mapper Functions Reference Guide
Version
7.3
Language
English
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development > Designing Jobs
Last publication date
2023-01-05

Use a SimpleLoop function with an AscendingSort function to sort elements in a loop based on their value.

Before you begin

You have created a map with an input and output structure. You can use the sample provided below.

About this task

In this example, you have a CSV file containing employee information. You want to sort the list of employees alphabetically by their last names. You can use the following CSV sample to create a structure and use it as both input and output in your map: 
firstName,lastName,salary
Steve,Rogers,185
Tony,Stark,200
Natasha,Romanoff,175
Bruce,Banner,150
Clint,Barton,135

Procedure

  1. Drag and drop the input row element on the corresponding output to map all child elements.
    A SimpleLoop function is automatically added to the output row loop.
  2. Drag and drop a AscendingSort function on the Sort Keys argument.
  3. Drag and drop the input lastName element on the AscendingSort function.

Results

Your map is configured and should look like this:
You can use the Test Run feature to see the result. In this example, the following output is returned: 
firstName,lastName,salary
Bruce,Banner,150
Clint,Barton,135
Steve,Rogers,185
Natasha,Romanoff,175
Tony,Stark,200