- Posts: 4
Limit Output Results by Criteria in DB Field
- B.Greenway
- Topic Author
- Offline
- User
Less
More
10 years 6 months ago #2329
by B.Greenway
Limit Output Results by Criteria in DB Field - Post(2329) was created 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
Thanks
Please Log in or Create an account to join the conversation.
- B.Greenway
- Topic Author
- Offline
- User
Less
More
- Posts: 4
10 years 6 months ago #2330
by B.Greenway
Replied by B.Greenway on topic Limit Output Results by Criteria in DB Field - Post(2330)
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 * fromWHERE BRAND="Brand"
In the read file > configure adapter, insert something to the effect of
select * from
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Offline
- Admin
10 years 6 months ago #2331
by FlowHeater-Team
Best wishes
Robert Stark
Replied by FlowHeater-Team on topic Limit Output Results by Criteria in DB Field - Post(2331)
Thanks for sharing your solution.
Just let me add some remarks.
Just let me add some remarks.
- 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 - 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
Please Log in or Create an account to join the conversation.
Time to create page: 0.257 seconds