topic Re: excel sheet loading in QlikView

excel sheet loading

Anonymous — Mon, 08 Dec 2014 11:09:05 GMT

when i try loading an excel file into qlikview that the header is appering but i want thee fields into table ..

Re: excel sheet loading

its_anandrjs — Mon, 08 Dec 2014 11:23:57 GMT

Hi,

Can you explain more please like which header you asking. Or you can try None in the labels.

Regards

Anand

Re: excel sheet loading

simenkg — Mon, 08 Dec 2014 11:27:16 GMT

When using the wizard just input the number of lines here:

Re: excel sheet loading

Anonymous — Mon, 08 Dec 2014 11:54:11 GMT

i can't get u .....Simen Kind Gulbrandsen

actually i want no governarate wilayat as fields...but its taking' please click' that header

Re: excel sheet loading

anbu1984 — Mon, 08 Dec 2014 11:59:22 GMT

LOAD no, governarate,wilayat

FROM

[File.xlsx]

(ooxml, explicit labels, header is 1 lines, table is Sheet1);

Re: excel sheet loading

Anonymous — Mon, 08 Dec 2014 12:00:34 GMT

actually i want no governarate wilayat as fields...but its taking' please click' that header

Re: excel sheet loading

simenkg — Mon, 08 Dec 2014 12:01:48 GMT

If you set header to be 1 line and use embedded labels, then it will take governarate and wilayat etc. as fields.

Re: excel sheet loading

its_anandrjs — Mon, 08 Dec 2014 12:02:12 GMT

Hi,

Try line 1 instead 2 as simen suggest is right

LOAD NO.,

Governate,

Willayat

......

FROM

TestSample.xlsx

Regards,

Anand

Re: excel sheet loading

Anonymous — Mon, 08 Dec 2014 12:18:12 GMT

thanq i am having 10 excel files with same fieldnames i want them to convert into 1 qvd how can i.

Re: excel sheet loading

simenkg — Mon, 08 Dec 2014 12:21:50 GMT

Load the first with a table name.

TableName:
Load *

from xls

...;

The following excel files preceed them with Concatenate (TableName).

Concatenate (TableName)

Load *

from xls

..;

Now if all your excel-files has the same format, i.e the same number of header lines, then you can simply read them all using wildcard in your filename.

TableName:
Load *

from Path\*.xls

...;

Re: excel sheet loading

its_anandrjs — Mon, 08 Dec 2014 12:23:06 GMT

Then Load all this way

Tab1:

LOAD NO.,

Governate,

Willayat

......

FROM

(ooxml, explicit labels, header is 1 lines, table is Sheet1);

Concatenate(Tab1):

LOAD NO.,

Governate,

Willayat

......

FROM

(ooxml, explicit labels, header is 1 lines, table is Sheet1);

After 10 concatenate you get single table and then

Store Tab1 into TableName.qvd;

Regards

Anand

Re: excel sheet loading

Anonymous — Mon, 08 Dec 2014 12:27:12 GMT

He:

LOAD * INLINE [

F1, F2

1, 2

22, 44

];

He2:

LOAD * INLINE [

F1, F2

45455rgcfdf, 5

22, 64

];

here once show me how to write....

Re: excel sheet loading

its_anandrjs — Mon, 08 Dec 2014 12:28:06 GMT

Hi,

Or by single syntax you can load all the 10 tables

TableName:

LOAD *

(ooxml, explicit labels, header is 1 lines, table is [$(*)]);

Store TableName into TableName.qvd;

Regards

Anand

Re: excel sheet loading

its_anandrjs — Mon, 08 Dec 2014 12:33:11 GMT

Try with

He:

LOAD * INLINE [

F1, F2

1, 2

22, 44

];

NoConcatenate

He2:

LOAD * INLINE [

F1, F2

45455rgcfdf, 5

22, 64

];

noconcatenate

New:

Load * Resident He;

DROP Table He;

Load F1,F2 Resident He2;

DROP Table He2;

Regards

Anand

Re: excel sheet loading

Anonymous — Mon, 08 Dec 2014 12:35:12 GMT

i m having excel sheets of different governerates and how can in single syntax ..

anand can u give me u r mailid i m fed up with so many queries .

Re: excel sheet loading

Anonymous — Mon, 08 Dec 2014 12:40:31 GMT

thanqq very much i will make use of this resident sytax its fine here we have to write all fields right ......

Re: excel sheet loading

its_anandrjs — Mon, 08 Dec 2014 12:43:18 GMT

Hi,

Please close the thread by appropriate answer selected for references. For new question post the new thread.

Regards

Anand

Re: excel sheet loading

simenkg — Mon, 08 Dec 2014 12:44:55 GMT

He:

LOAD * INLINE [

F1, F2

1, 2

22, 44

];

Concatenate(He)

LOAD * INLINE [

F1, F2

45455rgcfdf, 5

22, 64

];

Store He into He.qvd (qvd);

drop table He;

Re: excel sheet loading

Anonymous — Mon, 08 Dec 2014 12:48:33 GMT

i want to show u one pivot table query if u r free.... mail?

Re: excel sheet loading

its_anandrjs — Mon, 08 Dec 2014 12:53:16 GMT

Yes right this way all 10 or you better you can load all table at once.

Regards

Anand