Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Exclude the last row from the processing

More
11 years 9 months ago #2233 by Gennaro
Hi,
how can I exclude the last row (of a text file) from the flowheater 'read side' processing?

thanks

Please Log in to join the conversation.

More
11 years 9 months ago #2234 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:Exclude the last row from the processing
Hi Gennaro,

There are two possible ways. For these two ways I’ve made two examples, please have a look to the attachment.
  1. You filter these row(s) on the basis of one or more field content. If Field1 = abc and Field2 = xyz then this row can be filtered. In most cases this works, but in some cases you can’t find proper conditions.
  2. You count the available lines with the .NET Script Heater before the definition start. The Script in the .NET Script Heater opens the csv text flle and read all lines in memory and count the available lines. After that the available lines will be stored in the FlowHeater Parameter "LineInFile". This parameter in combination with the AutoID Heater is the filter condition of the Filter Heater. If AutoID Value >= $LineInFile$ then filter this line!
NOTE:
Solution 1) Filters all lines they are match the condition, not only the last line. But this solution can work with a lot of data.
Solution 2) Filters only the last x Line(s). But this solution can only work with small text (CSV) files. Maximum about 50-200 MB, depends on your hardware.

Attachment filter_last_csv_lines.zip not found


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 to join the conversation.

Time to create page: 0.282 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

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