topic Load data into qlikview using Load script.. in QlikView

Load data into qlikview using Load script..

Sat, 27 Apr 2013 17:22:52 GMT

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

Re: Load data into qlikview using Load script..

nilesh_gangurde — Sat, 27 Apr 2013 19:29:56 GMT

Hii mohammadsaif,

please mention the types.....

-Nilesh

Re: Load data into qlikview using Load script..

Sun, 28 Apr 2013 14:25:56 GMT

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.

Re: Load data into qlikview using Load script..

Sun, 28 Apr 2013 16:36:51 GMT

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

Re: Load data into qlikview using Load script..

nilesh_gangurde — Sun, 28 Apr 2013 18:30:13 GMT

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

Re: Load data into qlikview using Load script..

Gysbert_Wassenaar — Sun, 28 Apr 2013 19:00:20 GMT

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.

Re: Load data into qlikview using Load script..

Mon, 29 Apr 2013 06:06:52 GMT

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.

Re: Load data into qlikview using Load script..

jagan — Mon, 29 Apr 2013 08:37:23 GMT

HI,

Please check the following URL

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

Regards,

Jagan.