How to extract last record

[nihhalmca]

Hi All,

How to extract last record from table/file? we can extract first record by First function like Qlik has any function?

Thanks,

Nihhal.

[justinphamvn]

Hi Nihhal L,

I think you should add a column Rowno() on Script Load.

So you can sort it on your table (desc or asc it's up to you)

Thank you!

Justin