excel sheet loading

[Anonymous]

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

[its_anandrjs · Accepted solution]

Hi,

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

Regards

Anand

[simenkg]

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

[Anonymous]

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

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

[anbu1984]

LOAD no, governarate,wilayat

FROM

[File.xlsx]

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

[Anonymous]

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

[simenkg]

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

[its_anandrjs]

Hi,

Try line 1 instead 2 as simen suggest is right

LOAD NO.,

     Governate,

     Willayat

......

FROM

TestSample.xlsx

Regards,

Anand

[Anonymous]

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

[simenkg]

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

...;