Delete rows in qvd

[#1]

Hi all,

I have this problem.

from 3 csv I charge the situation of the incidents for my customer.

the csv are :

Incident Rised on Month

Incident Closed on Month

Incident Open ytd

I recharged all CSV in one QVD with incremental load where ID not Exist

is it possible, delete all Incident Open ( field Incident Status = 'OPEN' ) from QVD before to recharge the CSV :INCIDENT OPEN YTD ?

The sequence would is :

1)charge Incident Rised csv

   join with incident Closed csv

   join with QVD

2) DELETE rows with Incident Status = OPEN

3) charge Incident Open csv

     join with QVD

thanks in advanced

[maxgro · Accepted solution]

no, you can't delete from a .qvd file

2) should be a residente load (or some other method) to filter the non OPEN incident

1)

Tab1:

charge

..........

2)

Tmp: noconcatenate load * resident Tab1 where not match(IncidentStatus, 'OPEN');

drop table Tab1;

rename table Tmp to Tab1; // now in Tab1 you don't have open incident

3)

.....

[#3]

thanks