This function is only meaningful if used together with a while clause, see Load. IterNo( ) returns an integer indicating for which time one single record is evaluated in a load statement with a while clause. The first iteration has number 1.
- RecNo() function returns an integer for the position of the current row in the resulting qlikview table.
- RowNo() function counts the record in the row data table. It doesn't count the records that are included by where clauses and it isn't reset when a row data table is concatenate to another.The first row is number 1.
Let's see example below:
I have two table, table_A and table_B.
Num Letter Num Letter
1 bb 4 Bee
2 lyk 5 Ah
3 honi 6 Berry
Load * , RecNo(), RowNo() from table_A where Num <>3;
Load * , RecNo(), RowNo() from table_B where Num <>5;