how to get these in script level...pls hep me....

[#1]

hi all,

id            variable

001         13kh1d4567

002          13gh4t5467

003          12rt4s5678

001          65759

002           5674

003          7484

in script level I want to display the result like

id              variable

001          13kh1d4567,65759

002           13gh4t5467,5674

003           12rt4s5678,7484

Thanks,

kumar

[cwolf]

Load

id,

concat(variable,',')

resident table_name

group by id;

[settu_periasamy · Accepted solution]

One more,

Load id,Concat(variable,',') as variale Group by id;
LOAD * INLINE [
    id, variable
    001, 13kh1d4567
    002, 13gh4t5467
    003, 12rt4s5678
    001, 65759
    002, 5674
    003, 7484
];

[jagan]

Hi Kumar,

Try this using Group By and Concat() like below

Temp:

LOAD

*

FROM DataSource;

QVTableName:

NoConcatenate

Load

id,

Concat(variable, ',') AS variable

RESIDENT Temp

Group By id;

DROP TABLE Temp;

Hope this helps you.

Regards,

jagan.

[#5]

Thank you all....