topic Re: how to get these in script level...pls hep me.... in QlikView

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

Wed, 28 Oct 2015 04:10:58 GMT

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

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

cwolf — Wed, 28 Oct 2015 18:47:07 GMT

Load

id,

concat(variable,',')

resident table_name

group by id;

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

settu_periasamy — Thu, 29 Oct 2015 02:26:52 GMT

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

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

jagan — Thu, 29 Oct 2015 02:55:37 GMT

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.

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

Thu, 29 Oct 2015 07:08:41 GMT

Thank you all....