FlowHeater - The Data Import / Export Specialist
See also the general examples available, which may answer your question: Hello World 1 / 2 / 3 , format numbers as character strings , simple If-Then-Else , complex If-Then-ElseIf , filtering and grouping data , consolidate grouped values

Limit Output Results by Criteria in DB Field

  • B.Greenway
  • Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 7 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 or Create an account to join the conversation.

  • B.Greenway
  • Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 7 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 or Create an account to join the conversation.

More
8 years 7 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 or Create an account to join the conversation.

Time to create page: 0.385 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en