Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Find out the row number

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

6 Replies
settu_periasamy
Master III
Master III

Hi,

Try Like this

LOAD ID,

     Name,

     RecNo() as row1

FROM

[path\qv_help.xls]

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

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Yes ,we can find out by using ROW()

Example :

=Row(Your-value)

Not applicable
Author

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

settu_periasamy
Master III
Master III

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.

Capture.JPG

ashfaq_haseeb
Champion III
Champion III

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
Master III
Master III

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