Filtering loop elements on their value

Use a SimpleLoop function with a Greater function to filter elements in a loop based on their value.

firstName,lastName,salary
Steve,Rogers,185
Tony,Stark,200
Natasha,Romanoff,175
Bruce,Banner,150
Clint,Barton,135

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