Find out the row number

[#1]

Hi All,

Is it possible to find out the row number at which the data is present in the excel file.

e.g. in some files, if the column header is present at row no. 3, then in Qlikview , it should return row no 3.

Thanks,

Asma

[settu_periasamy]

Hi,

Try Like this

LOAD ID,

     Name,

     RecNo() as row1

FROM

[path\qv_help.xls]

(biff, no labels, table is Sheet1$);

[nagarjuna_kotha]

Yes ,we can find out by using ROW()

Example :

=Row(Your-value)

[#4]

I wish to find out the header row number based on the data present in the file. Is it possible?

[settu_periasamy]

don't you want the label of field name ? if yes, you can try this

LOAD @1,

     @2,

     RecNo() as row1

FROM

[path\qv_help.xls]

(biff, no labels, table is Sheet1$);

I Don't know the exact solution. may be this helps.

[ashfaq_haseeb]

Hi,

Try like this

LOAD @1,

     @2,

     RecNo() as row1

FROM

[path\qv_help.xls]

(biff, no labels, table is Sheet1$) where len(trim(@1))>0;

The first value loaded in row1 filled will be your header row number.

Hope it helps

Regards

ASHFAQ

[anbu1984]

Source:

LOAD @1,

     @2,

     RecNo() as RowNO

FROM

[path\qv_help.xls]

(biff, no labels, table is Sheet1$);

Header_RowNo:

Load RowNO Resident Source Where @1 = 'date_check' ; //Replace date_check by field name in your header