I have a table that has records like below.
ID Name Value 1 xxx AA 10 2 yyy B 20 3 AA zzz 11 4 xxx B 20 5 kkk C 30 6 qqq (AA) ZZ 10 7 AA 10
I would like to get common records and add values of those records. The expected output table is:
ID Name Value 1 AA 41 2 B 40 3 C 30
The above is just examples of few records. However, the table has more than 100 records and it is possible that, in future, records will be added dynamically. Note: I'm OK, if it picks up sub string those are duplicate and read this as single records.
How can I achieve this?