RowNo - script function

This function returns an integer for the position of the current row in the resulting QlikView internal table. The first row is number 1.

Syntax:  

RowNo( [TOTAL])

 

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.

Note: If you use preceding load, that is, a number of stacked LOAD statements reading from the same table, you can only use RowNo( ) in the top LOAD statement. If you use RowNo( ) in subsequent LOAD statements, 0 is returned.

Example: Load script

Raw data table load:

Tab1: LOAD * INLINE [A, B 1, aa 2,cc 3,ee]; Tab2: LOAD * INLINE [C, D 5, xx 4,yy 6,zz];
 

Loading record and row numbers for selected rows:

QTab:

LOAD *,

RecNo( ),

RowNo( )

resident Tab1 where A<>2;

 

LOAD

C as A,

D as B,

RecNo( ),

RowNo( )

resident Tab2 where A<>5;

 

//We don't need the source tables anymore, so we drop them

Drop tables Tab1, Tab2;

The resulting QlikView internal table:

A B RecNo( ) RowNo( )

1

aa

1

1

3

ee

3

2

4

yy

2

3

6

zz

3

4

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?