Deleting rows in qvd

[mert1917]

Hi All,

can you help to me please..

I have a qvd ;

load*from qwd1

qwd1

date	ID
01/05/2020	1
02/05/2020	2
03/05/2020	3
04/05/2020	4

I want to delete this date row (04/05/2020). how can i do this?

my target qvd;

date	ID
01/05/2020	1
02/05/2020	2
03/05/2020	3

regards

[Arthur_Fong]

Try this:

load*from qwd1
where text(date)<>'04/05/2020';

[agigliotti · Accepted solution]

there is no way to delete a qvd row.
you can only replace the qvd file in your script as below:

Tab1:
load * from qwd1 where date <> '04/05/2020';

store * from Tab1 into qwd1;

[mert1917]

I'm trying right now thank you very much

[alex00321]

Like @Arthur_Fong  mentioned, write as this:

Temp:

Load * from qvd1 where where text(date)<>'04/05/2020';(or using the ID field in your dataset)

Store temp into XXX.QVD(QVD);

Thanks!

[Durgadevikumar · Accepted solution]

Hi Hazar,

Good Day😊

You can delete the rows while loading the qvd files by using the transformation step.

Follow the below step to achieve,

load the qvd file-------> Enable transformation step-----> select the rows which you want to delete------->Click the delete marked--------->next and finish.

Now check in the table view form the selected row will be deleted.

Regards,

DurgadeviKumar

[mert1917]

Thank you so much Durgadevi:)