Load data into qlikview using Load script..

[#1]

How to load following type of excel data.....

Column1      Column2     Column3

ABC               A1               B1

                      A2               B2

                      A3               B3

XYZ                X1                Y1

                      X2                Y2

Please reply me ASAP

[nagaiank]

The following script will work.

LOAD If(len(Trim(Column1))=0,Peek(Column1),Column1) as Column1, Column2, Column3;

LOAD * Inline [

Column1,Column2,Column3

ABC,A1,B1

,A2,B2

,A3,B3

XYZ,X1,Y1

,X2,Y2

];