difference between recno() and rowno() ?

[Anonymous]

Hi

Both gives same output like

recno():

1

2

3

4

5

rowno():

1

2

3

4

5

then what is the use with when  i have to use these fun?

[alexandros17 · Accepted solution]

These functions do not have any parameters. The parentheses are however still required.

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.

The main difference is :

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.

that in your case do not apply ... so the result is the same

[hic]

RecNo() is the record number of the input to the Load statement.

RowNo() is the record number of the output of the Load statement.

See more on Counters in the Load

HIC

[Anonymous]

Hi,

Go thru below links:

http://community.qlik.com/docs/DOC-7063

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

Regards

Neetha