Skip to main content Skip to complementary content
  • New archived content: Talend MDM, Talend Data Catalog 8.0, and Talend 7.3 products reached their end of life in 2024. Their documentation was moved to the Talend Archive page and will no longer receive content updates.

Filtering loop elements on their value

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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here