Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Load data into qlikview using Load script..

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

1 Reply
nagaiank
Valued Contributor III

Re: Load data into qlikview using Load script..

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

];

Community Browser