Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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:)