topic Re: Load last row in QlikView

Load last row

farolito20 — Wed, 02 Jan 2013 15:48:20 GMT

How can I load just the last row from a table?

Re: Load last row

Gysbert_Wassenaar — Wed, 02 Jan 2013 15:59:27 GMT

Order the table descending on the field that determines what is the last row and load the first record:

Table1:

first 1

load * from table order by fieldx desc;

Re: Load last row

farolito20 — Wed, 02 Jan 2013 16:13:48 GMT

Thanks

Re: Load last row

msteedle — Wed, 02 Nov 2016 13:56:41 GMT

Especially if you just need one or two values from that row (an index, a timestamp), it is likely faster to use the Peek function and not load/order the data. Negative numbers for Peek's second parameter count starting from the end of the table, so -1 would be the value for the last row.

LET v_LatestTimestamp = Peek('Timestamp Field', -1, 'Table with Timestamp');