FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
Take a look at the available examples for the SqlServer Adapter , maybe your question can already be answered here: CSV text file import , flat file export , Import IDENTITY (Auto Increment) fields , CSV export divided into several files
  • Page:
  • 1

TOPIC: filtering rows with respect to its column code

filtering rows with respect to its column code 5 years 4 months ago #2298

if the rows in a text file are not identical data depending on a column called code.

for example if code=0003 for a single row then this row must inserted in a table of MS sql database.
but if code=0005 then this row must be written to other table in the MS sql database.


can this be done or not?

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

Last edit: by Saliba. Reason: text

filtering rows with respect to its column code 5 years 4 months ago #2299

Hi Saliba,

It’s possible but you need in this case for each code one separate FlowHeater definition (.fhd) file.

To filter rows you need the Filter Heater and the If-Then-Else Heater for the condition. In the Condition you have to define != (not equal) 0003, this means all rows they doesn’t match this code are filtered out. In the second FlowHeater Definition you have to define != 0005 and so on for further codes.





I’ve made a brief example how it’s works. Please have a look to the attachment.

NOTE: In the example I’ve used two times the TextFile Adapter on the READ and the WRITE side. For your purpose you have to switch the Adapter on the WRITE to the SQL Server Adapter and use the table you need.


File Attachment:

File Name: filter-rows.zip
File Size:3 KB

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.
Attachments:

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

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en