leehaut opened a new issue, #8308: URL: https://github.com/apache/hop/issues/8308
### What would you like to happen? ### Proposed behavior Add a Group By option to exclude rows from aggregation based on a boolean field: 1. **Ignore rows for aggregation** (checkbox) → `ignore_aggregate` 2. **Ignore field name** (field combo) → `field_ignore` When enabled, rows where the selected boolean field is `true`: - are **excluded from aggregation** (SUM, COUNT, AVG, ...) - still participate in **group detection** - with **Include all rows**, are still written to the output and receive the group aggregate values ### Example Input: | grp | amount | skip | |-----|--------|------| | A | 10 | false | | A | 20 | false | | A | 30 | false | | A | 100 | true | Config: - Group field: `grp` - Aggregates: `SUM(amount)`, `COUNT(amount)` - Ignore rows for aggregation: enabled - Ignore field name: `skip` Expected output: | grp | sum_amount | cnt | |-----|------------|-----| | A | 60 | 3 | Current (broken) output if XML is hand-edited: | grp | sum_amount | cnt | |-----|------------|-----| | A | 160 | 4 | ### Issue Priority Priority: 3 ### Issue Component Component: Hop Gui, Component: Transforms -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
