FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Process only record where a specific value is found

Process only record where a specific value is found 7 years 8 months ago #2102

  • Gennaro
  • Gennaro's Avatar Topic Author
  • Offline
  • Posts: 27
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 exmaple input file

Attachment Example_input_file.zip not found

Attachments:

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

Re:Process only record where a specific value is found 7 years 8 months ago #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.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

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

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
  • Page:
  • 1

other Languages

en
GB | US

de
DE | AT | CH

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en