Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to delete the last row in a table

Hi All,

I want to know, how to delete the last row in a table.

Date:

Load    Date

          ,Time

          ,Year

from Somthing.qvd;

Here I want to know How to delete the last row of the Date table.?

Thanks in advance.

Regards,

Kabilan K

1 Solution

Accepted Solutions
MVP
MVP

Re: How to delete the last row in a table

Hi

If you are loading from a qvd, you can use QvdNoOfRecords() to get the number of rows in a qvd.

Let vRows = QvdNoOfRecords('mydata.qvd) - 1;

First($vRows) Load .... From mydata.qvd;

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies
fdelacal
Valued Contributor

Re: How to delete the last row in a table

always has the same number of rows or increase this number?
you could use ..
First (10) Load ...... from ABC.CSV

(10) REPLACE WITH YOUR NUMBERS OF ROWS.

or

if you know the date

WHERE date < 'YYYY-MM-DD'

MVP
MVP

Re: How to delete the last row in a table

Hi

If you are loading from a qvd, you can use QvdNoOfRecords() to get the number of rows in a qvd.

Let vRows = QvdNoOfRecords('mydata.qvd) - 1;

First($vRows) Load .... From mydata.qvd;

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser