Pivot - Urgent

[Ravi_knime]

Hi Team I have a data set (Ref Below)
|ID|Location|Cases|
|3712023|BY446|1|
|3712023|BYZK1|1|
|3712023|BYZK1|1|
|3712023|BYZK1|1|
|3694016|BY359|3|
|3696001|BY572|0|
|3698017|BY271|0|
|3698022|BYSR1|1|
|3702010|BYGZ1|1|
|3866021|BY647|1|
|3866021|BYHG7|1|
|3866021|BYHG7|1|
|3866021|BYHG7|1|
|3866021|BYHG7|1|

I Want ID level Location wise Sum of Cases like this
|ID|Location|Total|
|3694016|BY359|3|
|3696001|BY572|0|
|3698017|BY271|0|
|3698022|BYSR1|1|
|3702010|BYGZ1|1|
|3712023|BY446|1|
|3712023|BYZK1|3|
|3866021|BY647|1|
|3866021|BYHG7|4|

[Aswin]

Use the GroupBy node. Use the first two columns as grouping columns, then use the sum operation on the third.