Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe like this?
TABLE:
LOAD * INLINE [
Key1, Value
A, 10
B, 20
];
LOAD 'C' as Key1,
sum(Value) as Value
Resident TABLE;