- Posts: 27
Process only record where a specific value is found
- Gennaro
- Topic Author
- Offline
- User
Less
More
13 years 8 months ago #2102
by Gennaro
Process only record where a specific value is found - Post(2102) was created by Gennaro
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
How can I do with flowheater? Thank you.
See, please, the attched file for an example input file
Attachment Example_input_file.zip not found
Attachments:
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Offline
- Admin
13 years 8 months ago #2104
by FlowHeater-Team
Best wishes
Robert Stark
Replied by FlowHeater-Team on topic Re:Process only record where a specific value is found - Post(2104)
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.
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.
Best wishes
Robert Stark
Please Log in or Create an account to join the conversation.
Time to create page: 0.250 seconds