To read only one row from excel

[#1]

Hi Experts,

    i have an excel file with header and fileds in it. i want to read only header while  importing in to qlikview

    Please find the attached sample excel file  in that i have to read only first row

    Any help would be appreciated

[MK_QSL]

Load

     Field1,

     Field2,

     FIeld3

From .....TableName

Where RowNo() < 0;

[#3 · Accepted solution]

Hi Sruti,

Go to Edit script, Click on Table Files button to start File type wizard.

Select your excel , mark header Size as None and  Labels as None. This will make the header record as first row of the table. Then click Next twice and click where clause button.

Select Advance and write WHERE ( RowNo() < 1 ). Then click finish and reload.

The script generated should look something like this

MyHeaders:  // <--Give some name  to the table here

LOAD A,

     B,

     C,

     D,

     E

FROM

test2.xlsx

(ooxml, no labels, table is Sheet1)

WHERE(RowNo() < 1 );

Regards,

Kalpesh