row no or rec no

[Mahamed_Qlik]

Hi 

Rowno() or Recno() showing multiple records for single ID.

I have below table:

Table

ID

101

102

103

Case 1:

if I write where clause to ID ='101', I am getting two records

ID              RowNo()    RecNo()

101          1                     1

101          2                     2

Case 2:

if I write where clause to ID ='102', I am getting two records

ID              RowNo()    RecNo()

102            1                     1

We want result as case2 only means for each ID it should show row or rec as one record only.

[PrashantSangle]

check in your data.. that there is actual one record or two record of Id 101.