Adding an extra value to a feild

Fri, 25 Oct 2013 14:59:17 GMT

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

Pls see attachment

Re: Adding an extra value to a feild

swuehl — Fri, 25 Oct 2013 15:14:26 GMT

Maybe like this?

TABLE:

LOAD * INLINE [

Key1, Value

A, 10

B, 20

];

LOAD 'C' as Key1,

sum(Value) as Value

Resident TABLE;