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: 
rajareddyjkl
Contributor III
Contributor III

last 100 records

hi 

i have  one table i  want  last  100 records in  table

4 Replies
Anil_Babu_Samineni

How about this?

Table:

First 10

Load * From Table Order By FieldName Desc;

OR

Table:

Load * from Table;

NoConcatenate

Final:

First 10

LOAD * Resident Table Order By FieldName desc;

DROP Table Table;

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
poppypearce
Creator
Creator

try using peek function in your load script..

its_anandrjs

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

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