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........ Please reply me ASAP..

7 Replies
nilesh_gangurde
Valued Contributor

Re: Load data into qlikview using Load script..

Hii mohammadsaif,

please mention the types.....

-Nilesh

Not applicable

Re: Load data into qlikview using Load script..

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.

Not applicable

Re: Load data into qlikview using Load script..

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
Valued Contributor

Re: Load data into qlikview using Load script..

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..

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.


talk is cheap, supply exceeds demand
Not applicable

Re: Load data into qlikview using Load script..

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.

MVP
MVP

Re: Load data into qlikview using Load script..

HI,

Please check the following URL

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

Regards,

Jagan.

Community Browser