sum the records based on ID column and give a output

[prabuj]

Hi Team @rhall

I want to add the records based on the first column:

Input:

|190  |test1      |2    |

|190  |test2      |1    |

|290  |test3      |1    |

|290  |test4      |2    |

|190  |test5      |1    |

|190  |test6      |1    |

|290  |test7      |2    |

|290  |test8      |1    |

|290  |test9      |1    |

'------+-----------------+-

Required Output

|190  |test1      |5    |

|190  |test2      |5    |

|290  |test3      |7    |

|290  |test4      |7    |

|190  |test5      |5    |

|190  |test6      |5    |

|290  |test7      |7    |

|290  |test8      |7    |

|290  |test9      |7   |

'------+-----------------+-

Thanks,

Prabuj

[Mahamoutou]

Here is a way to go :