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

Limit Output Results by Criteria in DB Field

More
9 years 9 months ago #2329 by B.Greenway
I have a product database of over 40k records, I want to export an excel sheet of all items from a specific brand, whats the best way to accomplish this?

Thanks

Please Log in to join the conversation.

More
9 years 9 months ago #2330 by B.Greenway
Replied by B.Greenway on topic Limit Output Results by Criteria in DB Field
Well, I've found my own answer, thought I'd share it

In the read file > configure adapter, insert something to the effect of

select * from WHERE BRAND="Brand"

into the SQL tab under Fields/Data types.

Please Log in to join the conversation.

More
9 years 9 months ago #2331 by FlowHeater-Team
Replied by FlowHeater-Team on topic Limit Output Results by Criteria in DB Field
Thanks for sharing your solution.

Just let me add some remarks.
  1. In your SQL WHERE statement you could also use FlowHeater Parameters like this

    select select * from WHERE BRAND = "$BRAND$"

    In this case you can override the parameter value with the Batch Module option /SetParameter BRAND=otherBrand

  2. Another way to filter some records is to use the Filter Heater together with the IF-THEN-ELSE Heater for the filter condition. Here you’ll find two examples how you could to this.

    NOTE: Your used way is much faster because in this case FlowHeater hasn’t to proceed the whole records.

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

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