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

[#1]

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

[alexandros17]

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]

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]

But what about if we have 100 rows to delete ?

[alexandros17]

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

[kavita25]

You can use conditions for that instead of where clause.

[Anonymous]

Hi,

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

[#8]

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]

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

[marcus_malinow]

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