Group By Node : Result Based On Group By Specified Group
Hello Knime Masters,
I have a question if the GroupBy node (or any other node) can do the following.
| Item Name | Value | |
| Item No.1 | 1 | |
| Item No.1 | 2 | |
| Item No.2 | 5 | |
| Item No.1 | 2 | |
| Item No.3 | 10 | |
| Item No.2 | 1 | |
| Item No.2 | 2 | |
| Item No.2 | 3 | |
| How to get the result like | | |
| Item Name | Count | Value |
| Item No.1 | 3 | 5 |
| Item No.2 | 4 | 11 |
| Item No.3 | 1 | 10 |Thanks & Regards