Rownum,Rowid

[qlikview979]

Hi experts,

What is the difference between rownum & rowid ?

[awhitfield]

Do you mean RowNo() and RecNo()?

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.

Andy

[MK_QSL]

Is there any function RowID() in QlikView?

[marcus_malinow]

RecNo or RowNo?‌

[Anonymous]

RowNo( ),Returns an integer for the position of the current row in the resulting QlikView internal table.  RecNo () , which counts the records in the table of pure data, RowNo () function does not count records excluded by clause where  and is not reset when a pure table Concatenation with another.

[anbu1984]

Rownum and Rowid are present in Oracle

http://www.dba-oracle.com/t_rownum_rowid_difference.htm/