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

Can FlowHeater read from a specified record number

More
6 years 11 months ago #3175 by Ken Starnes
I need to be able to read data from an Access table but from a starting record number.
Does FlowHeater enable me to do this?
Or do I have to read all records and then externally remove the unwanted ones?

Thanks

Please Log in to join the conversation.

More
6 years 11 months ago #3177 by FlowHeater-Team
Replied by FlowHeater-Team on topic Can FlowHeater read from a specified record number
Hi Ken,

Of course yes :-) FlowHeater supports more than one way to do this.
  1. In case you would like to skip just the first 100 records you can use the AutoID Heater in combination with the IF-THEN-ELSE Heater for the condition and last but not least the Filter Heater to filter out the unwanted records. You´ll find a brief example attached in the ZIP archive -> filter-records-I.fhd

  2. In case your Access Database Table has an Auto Increment Primary Key field you have two more option.
    First) Like above use the ID value from the Field and filter the unwanted records. You´ll find a brief example attached in the ZIP archive -> filter-records-II.fhd

    Second) you just use an “WHERE” in the Access Adapter READ SQL Statement like this: “select * from your_table where ID >= 100”

Note: FlowHeater supports also dynamical to export since last export only new added records. You´ll find an detailed example here: Exporting only new MySQL records to a CSV text file


File Attachment:

File Name: filter-records.zip
File Size:4 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 to join the conversation.

More
6 years 11 months ago #3179 by Ken Starnes
Replied by Ken Starnes on topic Can FlowHeater read from a specified record number
Thanks Robert - that seems to have fixed things.

Please Log in to join the conversation.

Time to create page: 0.368 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.