Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

IterNo(),RecNo(),RowNo()

HI,

when we use IterNo()..?

Diff for Recno(), RowNo()...i hope both r same...wts d diff?

@Sub2u

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

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

On IterNo(): Just as Robert says - it is only meaningful together with a While clause. See the example on Creating Reference Dates for Intervals

HIC

View solution in original post

4 Replies
maxgro
MVP
MVP

here

RecNo or RowNo?

if you try the search function, upper right, ......

robert_mika
Master III
Master III

From Qlikview help:

IterNo( )

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.

hic
Former Employee
Former Employee

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

On IterNo(): Just as Robert says - it is only meaningful together with a While clause. See the example on Creating Reference Dates for Intervals

HIC

Not applicable
Author

-  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.

          Table_A                                                Table_B

Num           Letter                                    Num          Letter

1                    bb                                        4               Bee

2                    lyk                                        5               Ah

3                    honi                                     6               Berry

Script:

     Load * , RecNo(), RowNo()  from  table_A where Num <>3;

     Load * , RecNo(), RowNo()  from table_B where Num <>5;

Result:

Num          Letter         RecNo()          RowNo()

1                    bb               1                    1

2                    lyk               2                    2

4                    Bee            4                    3

6                    Berry          6                    4