topic Re: Find out the row number in QlikView

Find out the row number

Thu, 09 Apr 2015 09:42:37 GMT

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

Re: Find out the row number

settu_periasamy — Thu, 09 Apr 2015 09:54:06 GMT

Hi,

Try Like this

LOAD ID,

Name,

RecNo() as row1

FROM

[path\qv_help.xls]

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

Re: Find out the row number

nagarjuna_kotha — Thu, 09 Apr 2015 10:01:52 GMT

Yes ,we can find out by using ROW()

Example :

=Row(Your-value)

Re: Find out the row number

Thu, 09 Apr 2015 10:22:21 GMT

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

Re: Find out the row number

settu_periasamy — Thu, 09 Apr 2015 10:35:39 GMT

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.

Re: Find out the row number

ashfaq_haseeb — Thu, 09 Apr 2015 10:38:42 GMT

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

Re: Find out the row number

anbu1984 — Thu, 09 Apr 2015 10:50:38 GMT

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