Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
These functions do not have any parameters. The parentheses are however still required.
Returns an integer for the number of the currently read row of the internal table. The first record is number 1.
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
These functions do not have any parameters. The parentheses are however still required.
Returns an integer for the number of the currently read row of the internal table. The first record is number 1.
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
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
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