How to split the values into a field

[karan_kn]

How to split the values into a field? to convert aid, bid, cid as field with respective values

LOAD * INLINE [
SID, Svalue
aid, 18400361
aid, 50553345190
bid, 5273072
cid, 7844701
bid, 69615369
cid, 2214567
aid, 47216
cid, 3247611828
bid, 3163
aid, 6589344
];

[andrespa]

Hi, maybe something like this:

Table_aux:
LOAD * INLINE [
SID, Svalue
aid, 18400361
aid, 50553345190
bid, 5273072
cid, 7844701
bid, 69615369
cid, 2214567
aid, 47216
cid, 3247611828
bid, 3163
aid, 6589344
];

Table:
LOAD
Sum(Svalue),
SID
Resident Table_aux
Group by SID;

Drop table Table_aux;

Hope it helps,

Andrés

[karan_kn]

Thanks for the reply, but my requirement to convert aid, bid, cid as a fields

[Channa]

use generic load

[jonathandienst]

You are looking for something like a generic load, but you don't have enough data. For example, whichvalues of aid would be linked with each value of bid and cid? You need some sort of key or object identifier and a GENERIC LOAD. See the help here:

Generic Databases

Generic Load