Skip to main content Skip to complementary content

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!