topic Re: Rowno( ) and Recno( ) in QlikView

Rowno( ) and Recno( )

Fri, 25 Apr 2014 13:01:59 GMT

Hello All,

What is difference between Rowno( ) and Recno( ).

Re: Rowno( ) and Recno( )

its_anandrjs — Fri, 25 Apr 2014 13:03:14 GMT

Have a look it is from help and see the difference.

RecNo( )

Returns an integer for the number of the currently read row of the internal table. The first record is number 1.

RowNo( )

Returns an integer for the position of the current row in the resulting QlikView internal table. In contrast to RecNo( ), which counts the records in the raw data table, the RowNo( ) function does not count records that are excluded by where clauses and is not reset when a raw data table is Concatenation to another. The first row is number 1.

Examples:

Raw data tables:

Tab1.csv
A	B
1	aa
2	cc
3	ee

Tab2.csv
A	B
5	xx
4	yy
6	zz

QVTab:

Load *, RecNo( ), RowNo( ) from Tab1.csv where A<>2;

Load *, RecNo( ), RowNo( ) from Tab2.csv where A<>5;

The resulting QlikView internal table:

QVTab
A	B	RecNo( )	RowNo( )
1	aa	1	1
3	ee	3	2
4	yy	2	3
6	zz	3	4

Re: Rowno( ) and Recno( )

maxgro — Fri, 25 Apr 2014 13:03:52 GMT

from online help

RecNo( )

Returns an integer for the number of the currently read row of the source data table. The first record is number 1.

RowNo( )

Returns an integer for the position of the current row in the resulting QlikView internal table. In contrast to RecNo( ), which counts the records in the raw data table, the RowNo( ) function does not count records that are excluded by where clauses and is not reset when a raw data table is concatenated to another. The first row is number 1.

Re: Rowno( ) and Recno( )

bharath28 — Fri, 25 Apr 2014 13:08:01 GMT

http://community.qlik.com/blogs/qlikviewdesignblog/2013/09/16/counters-in-the-load

Please refer the link

Re: Rowno( ) and Recno( )

Fri, 25 Apr 2014 13:21:22 GMT

What is difference when both creating the same numbers.

Re: Rowno( ) and Recno( )

its_anandrjs — Fri, 25 Apr 2014 13:24:34 GMT

It is not different see with the example

T1:

LOAD * Inline

[

A,B

1,aa

2,cc

3,ee

];

NoConcatenate

qvtab:

LOAD *,RecNo( ),RowNo( ) Resident A Where A<>2;

DROP Table T1;

When you read the table T1 with A <> 2 then you get below table

Where you see Recno() has only 1 and 3 but Rowno() gives total row loaded in the table.

A	B	RecNo()	RowNo()
1	aa	1	1
3	ee	3	2

Re: Rowno( ) and Recno( )

ashfaq_haseeb — Mon, 13 Oct 2014 09:38:41 GMT

Hi,

Check this

http://community.qlik.com/blogs/qlikviewdesignblog/2014/08/29/recno-or-rowno

Regards

ASHFAQ