Skip to main content
simply more productive
The Data Specialist

✅ Easy data integration - import/export
✅ No programming required thanks to visual modeling
✅ Simple ETL tool with versatile options

Flowheater Chart

Process only record where a specific value is found

More
15 years 4 months ago #2102 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

Attachment Example_input_file.zip not found

Please Log in or Create an account to join the conversation.

More
15 years 4 months ago #2104 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:Process only record where a specific value is found
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.

Best wishes
Robert Stark

Please Log in or Create an account to join the conversation.

Time to create page: 0.141 seconds
FlowHeater Logo
FlowHeater - The Data Specialist
Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.
Legal information
Support & Contact
Contact

Phone:
0951 / 9933 9792

eMail:
info@flowheater.net


Copyright © 2009-2026 by FlowHeater GmbH. All rights reserved.