Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
What is difference between Rowno( ) and Recno( ).
QV
It is not different see with the example
T1:
LOAD * Inline
[
A,B
1,aa
2,cc
3,ee
];
NoConcatenate
qvtab:
LOAD *,RecNo( ),RowNo( ) Resident A Where A<>2;
DROP Table T1;
When you read the table T1 with A <> 2 then you get below table
Where you see Recno() has only 1 and 3 but Rowno() gives total row loaded in the table.
A | B | RecNo() | RowNo() |
1 | aa | 1 | 1 |
3 | ee | 3 | 2 |
Have a look it is from help and see the difference.
Returns an integer for the number of the currently read row of the internal table. The first record is number 1.
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 Concatenation to another. The first row is number 1.
Examples:
Raw data tables:
Tab1.csv | |
A | B |
1 | aa |
2 | cc |
3 | ee |
Tab2.csv | |
A | B |
5 | xx |
4 | yy |
6 | zz |
QVTab:
Load *, RecNo( ), RowNo( ) from Tab1.csv where A<>2;
Load *, RecNo( ), RowNo( ) from Tab2.csv where A<>5;
The resulting QlikView internal table:
QVTab | |||
A | B | RecNo( ) | RowNo( ) |
1 | aa | 1 | 1 |
3 | ee | 3 | 2 |
4 | yy | 2 | 3 |
6 | zz | 3 | 4 |
from online help
Returns an integer for the number of the currently read row of the source data table. The first record is number 1.
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.
http://community.qlik.com/blogs/qlikviewdesignblog/2013/09/16/counters-in-the-load
Please refer the link
What is difference when both creating the same numbers.
It is not different see with the example
T1:
LOAD * Inline
[
A,B
1,aa
2,cc
3,ee
];
NoConcatenate
qvtab:
LOAD *,RecNo( ),RowNo( ) Resident A Where A<>2;
DROP Table T1;
When you read the table T1 with A <> 2 then you get below table
Where you see Recno() has only 1 and 3 but Rowno() gives total row loaded in the table.
A | B | RecNo() | RowNo() |
1 | aa | 1 | 1 |
3 | ee | 3 | 2 |
Hi,
Check this
http://community.qlik.com/blogs/qlikviewdesignblog/2014/08/29/recno-or-rowno
Regards
ASHFAQ