Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
mert1917
Contributor III
Contributor III

Deleting rows in qvd

Hi All,

can you help to me please..

I have a qvd ;

load*from qwd1

qwd1

dateID
01/05/20201
02/05/20202
03/05/20203
04/05/20204

 

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

my target qvd;

dateID
01/05/20201
02/05/20202
03/05/20203

 

regards

 

 

 

 

 

 

2 Solutions

Accepted Solutions
agigliotti
Partner - Champion
Partner - Champion

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;

View solution in original post

Durgadevikumar
Partner - Contributor III
Partner - Contributor III

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.

delete1.PNGdelet2.PNG

Regards,

DurgadeviKumar

View solution in original post

6 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try this:

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

agigliotti
Partner - Champion
Partner - Champion

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
Contributor III
Contributor III
Author

I'm trying right now thank you very much

alex00321
Creator II
Creator II

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
Partner - Contributor III
Partner - Contributor III

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.

delete1.PNGdelet2.PNG

Regards,

DurgadeviKumar

mert1917
Contributor III
Contributor III
Author

Thank you so much Durgadevi:)