Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Not applicable

How to delete a specific row from the qvd without the 'where' clause?

Hi,

I have a qvd file in which I want to delete some specific row without the using of 'where' clause. Because if I use the where clause that time I have to load the full data I did not want that.

Thanking You

Regards

Anup

12 Replies

Re: How to delete a specific row from the qvd without the 'where' clause?

If you want to do any operation on a qvd you have to load it all ... there are not other options unfortinately.

Hope it helps

Partner
Partner

Re: How to delete a specific row from the qvd without the 'where' clause?

Hi,

You can delete rows by using Transformation Step while loading the QVD.

As you can see in the screenshot, row no.6 is selected.

After that on clicking the "Delete Marked " button on the left side, Row no.6 will be deleted.

Regards,

Kavita

nikhilgarg
Valued Contributor

Re: How to delete a specific row from the qvd without the 'where' clause?

But what about if we have 100 rows to delete ?

Re: How to delete a specific row from the qvd without the 'where' clause?

But what about if we have 1000 rows to delete among 2000000 of rows?

Partner
Partner

Re: How to delete a specific row from the qvd without the 'where' clause?

You can use conditions for that instead of where clause.

neetha_p
Honored Contributor

Re: How to delete a specific row from the qvd without the 'where' clause?

Hi,

Use incremental load for updating QVDs based on source DB,no other option than full load.

Not applicable

Re: How to delete a specific row from the qvd without the 'where' clause?

Thank You all of you for the response. Actually I want to update the qvd. Suppose I want to insert some new row, modify the existing row and want to delete some row. Please suggest what to do?

Thanking You

Regards

Anup

Re: How to delete a specific row from the qvd without the 'where' clause?

Searcg QVD on help, you will find all the answers with examples ...

marcus_malinow
Valued Contributor III

Re: How to delete a specific row from the qvd without the 'where' clause?

Hi Anup,

it sounds very much like you'll have to implement an incremental load here.

There are plenty of resources here in the community to steer you in the right direction, but in summary your load would look something like this:

[Facts]:

LOAD [fields];

SQL SELECT [fields]

FROM [dbtable]

CONCATENATE (Facts)

LOAD *

FROM [existing QVD]

WHERE NOT EXISTS (keyfield) //this covers the modified records

AND NOT (deletion clause); //this covers the deleted records

STORE Facts INTO [existing QVD];

Marcus