Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
karan_kn
Creator II
Creator II

How to split the values into a field

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
];

 

4 Replies
andrespa
Specialist
Specialist

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
Creator II
Creator II
Author

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

 

Channa
Specialist III
Specialist III

use generic load

Channa
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein