topic Re: last 100 records from source table in QlikView

last 100 records

rajareddyjkl — Wed, 25 Nov 2020 16:16:04 GMT

i have one table i want last 100 records in table

Anil_Babu_Samineni — Sun, 24 Sep 2017 18:59:36 GMT

How about this?

Table:

First 10

Load * From Table Order By FieldName Desc;

Table:

Load * from Table;

NoConcatenate

Final:

First 10

LOAD * Resident Table Order By FieldName desc;

DROP Table Table;

poppypearce — Mon, 25 Sep 2017 05:58:59 GMT

try using peek function in your load script..

its_anandrjs — Mon, 25 Sep 2017 06:26:59 GMT

In your table add one field for counting the rows Ex:- Rowno() as Rid and then use this field to load last 100 data from the table.

NoConcatenate

LOAD * Resident SourceTable Where Rid > 100;

DROP Table SourceTable;

navin — Thu, 26 Sep 2019 08:30:58 GMT

Table :
Load
RecNo() as Sno,
RowNo() as Rownum
resident Transact where Sno<=100 order by Sno desc ; //Transact is already loaded table .