Adding an extra value to a feild

[#1]

Dear All

I am having table contains the two field key and value. I want to add an extra value as C to feild Key.

which can have a value of A+B.

So C can have 30 in the table how can i achieve this??

I/O

Key	Value
A	10
B	20

O/P

Key	Value
A	10
B	20
C	30

Pls see attachment

[swuehl]

Maybe like this?

TABLE:

LOAD * INLINE [

    Key1, Value

    A, 10

    B, 20

];

LOAD 'C' as Key1,

          sum(Value) as Value

Resident TABLE;