Skip to main content
simply more productive
The Data Specialist

✅ Perfect for data integration-import/export
✅ No programming required thanks to visual modeling
✅ No registration required

Flowheater Chart

Grouping and Summing with If Condition

More
#2071 by Gennaro
hi, i need to group only some records of an excel input file, and only if some conditions are met.
i've tried using the group by and "if" functions but with no luck, please see below for an example, any suggestion would be very well accepted. thankx in advance.

This attachment is hidden for guests.
Please log in or register to see it.

Please Log in or Create an account to join the conversation.

More
#2072 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:Grouping and Summing with If Condition
Hi Gennaro,

That's a really nice challenge :) Yes, FlowHeater can handle it, but it’s a bit tricky. I have made an example to demonstrate this. Please have a look to the attachment "grouping_and_summing_with_condition.zip"

In the example I'm used the TextFile Adapter for READ (import.csv) and WRITE (output.csv). You can it simple to port to use it with the Excel Adapter . The TextFile Adapter is just a bit faster.

The example used How it's works:
First the If-Then-Else Heater checks the field "type" with the criteria "in". If the value match (=in) the string append heater appended the fields “code” and "type" and pass it to the GroupBy Heater. If the criteria don’t match the AutoID Heater generates a new number (+1) and passes it to the GroupBy Heater. The GroupBy Heater only grouping rows together if the same consecutive equally value are passed! In the else case there are never the same value because the AutoID Heater, that’s the trick. The Additions Heater just summing the incoming values by the group.

This attachment is hidden for guests.
Please log in or register to see it.


Best wishes
Robert Stark

Please Log in or Create an account to join the conversation.

More
#3483 by Daniel
Replied by Daniel on topic Re:Grouping and Summing with If Condition
Hi, I am trying to do something similar. Would be grateful if you could repost this solution so I could view it in the latest version of Flowheater.

Also, I can't figure out how to trim a string to contain just the first three words, that are separated by spaces.
Example
Read side:
"foo bar foo bla bla blah"
Write side:
"foo bar foo"

Thank you! This program is awesome!

Please Log in or Create an account to join the conversation.

More
#3484 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:Grouping and Summing with If Condition
Hi Daniel,

Please find attached the converted example, this works now with the current version 4.1.3.1. In the ZIP archive you´ll find also a short example how to split just the first three words of a string. For this you need three String Split Heater and on String Append Heater to append the first three words to one string again.

This attachment is hidden for guests.
Please log in or register to see it.

Best wishes
Robert Stark

Please Log in or Create an account to join the conversation.

Time to create page: 0.234 seconds
FlowHeater Logo
FlowHeater - The Data Specialist
Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.
Legal information
Support & Contact
Contact

Phone:
0951 / 9933 9792

eMail:
info@flowheater.net


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