Filtering loop elements on their value - 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 a Greater function to filter 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, including salaries. You want to filter this data to keep only the employees with a salary above 150. 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 Greater function on the Filter argument of the SimpleLoop.
  3. Drag and drop the input salary element on the First Value argument.
  4. Drag and drop a Constant function on the Second Value argument.
  5. Double-click the Constant function and enter 150 in the Value field, then click OK.

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
Steve,Rogers,185
Tony,Stark,200
Natasha,Romanoff,175