topic Re: Deleting rows in qvd in QlikView

Deleting rows in qvd

mert1917 — Fri, 15 May 2020 07:59:36 GMT

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

Re: Deleting rows in qvd

Arthur_Fong — Fri, 15 May 2020 08:06:32 GMT

Try this:

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

Re: Deleting rows in qvd

agigliotti — Fri, 15 May 2020 08:09:05 GMT

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;

Re: Deleting rows in qvd

mert1917 — Fri, 15 May 2020 08:10:58 GMT

I'm trying right now thank you very much

Re: Deleting rows in qvd

alex00321 — Fri, 15 May 2020 08:12:45 GMT

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!

Re: Deleting rows in qvd

Durgadevikumar — Mon, 18 May 2020 05:51:32 GMT

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

Re: Deleting rows in qvd

mert1917 — Tue, 19 May 2020 09:01:29 GMT

Thank you so much Durgadevi:)