I need to process (read side) only the records with a specific field value: when this value is found (i.e. "5"), then the record cointaing the field "5" must be passed to the write side.
How can I do with flowheater? Thank you.
See, please, the attched file for an example input file
This attachment is hidden for guests. Please log in or register to see it.
For this you have to move one
If-Then-Else Heater
and one
Filter Heater
on the Designer. Connect the certain field with the If-Then-Else Heater. The Output from the If-Then-Else Heater you have to connect to the Filter Heater.
After that double click the If-Then-Else Heater and enter your condition. If you want to pass all rows with the value 5 you have to use the condition
!= 5
Is the value of the certain field = 5 In this case the If-Then-Else Heater returns false to the Filter Heater and the row are not filtered. In other cases (value <> 5) the If-Then-Else Heater returns true = the given row are filtered.