topic Re: To read only one row from excel in QlikView

To read only one row from excel

Sun, 14 Sep 2014 07:38:06 GMT

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

Re: To read only one row from excel

MK_QSL — Sun, 14 Sep 2014 07:43:53 GMT

Load

Field1,

Field2,

FIeld3

From .....TableName

Where RowNo() < 0;

Re: To read only one row from excel

Sun, 14 Sep 2014 08:06:29 GMT

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,

FROM

test2.xlsx

(ooxml, no labels, table is Sheet1)

WHERE(RowNo() < 1 );

Regards,

Kalpesh