Load data into qlikview using Load script..

[#1]

How to load following type of excel data........ Please reply me ASAP..

[nilesh_gangurde]

Hii mohammadsaif,

please mention the types.....

-Nilesh

[#3]

Hii mohammadsaif,,

Normally we load data from excel by selecting a excel file with data in select datasource tab create new document workflow tab.

in your question you just mentioned 'load following type of excel data' and didn't list any data.

[#4]

Actually image is not pasted..... anyways

i want to load following type of data

Column1       Column2       Column3

ABC               A1               B1

                      A2               B2

XYZ                 X1               Y1

                       X2               Y2

[nilesh_gangurde]

Hii mohammadsaif,

If you have excel file having the data as above. just load the file into QV.

I am not able to understand what is the difficulty you are facing.

please elaborate your Question.

-Nilesh

[Gysbert_Wassenaar]

You can add a load filter to fill in empty values:

Load Column1, Column2, Column3

FROM

Map1.xlsx

(ooxml, embedded labels, table is Table1, filters(Replace(1, top, StrCnd(null))));

You can build such a filter with the transformation wizard. See here for an example.

[#7]

clicking Table tab 

Load your data

Next from File Wizard : File Wizard : TransaFormation

Enable Transformation Steps

go to Fill Tab

click "Fill" Button

Specifiy the target Column and go to Cell Condition and say ok without changing any settings

once you say ok, now you`d see the empty rows would have been filled with the informations and say Next and Finsih.

[jagan]

HI,

Please check the following URL

http://community.qlik.com/message/339830#339830

Regards,

Jagan.