Very Urgent Help required for Qlikview scripting

Fri, 29 Mar 2013 14:58:15 GMT

I have data in following format:

IF Name is same then all the respective values for Blend, Milled and unmilled should get in one row(seprated by'/')

How I can make it in following format?

Thanx in advance..

-Pradnya

Re: Very Urgent Help required for Qlikview scripting

rwunderlich — Fri, 29 Mar 2013 15:40:56 GMT

LOAD Name,

concat(Blend,'/') as Blend,

concat(Milled,'/') as Milled,

concat(Unmilled,'/') as Unmilled

FROM

(html, codepage is 1252, embedded labels, table is @1)

GROUP BY Name

;

-Rob