Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
alexandros17
Partner - Champion III
Partner - Champion III

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

kavita25
Partner - Specialist
Partner - Specialist

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
Specialist II
Specialist II

But what about if we have 100 rows to delete ?

alexandros17
Partner - Champion III
Partner - Champion III

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

kavita25
Partner - Specialist
Partner - Specialist

You can use conditions for that instead of where clause.

Anonymous
Not applicable
Author

Hi,

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

Not applicable
Author

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

alexandros17
Partner - Champion III
Partner - Champion III

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

marcus_malinow
Partner - Specialist III
Partner - Specialist III

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