topic Re: How to delete a particular data in a QVD in QlikView

How to delete a particular data in a QVD

shakthii — Sat, 16 Nov 2024 02:39:29 GMT

I have a requirement where I was asked to delete a particular record in QVD which is no longer present in the source system. Could you please help me with how to proceed doing it.

Re: How to delete a particular data in a QVD

jpenuliar — Fri, 23 Aug 2019 09:39:19 GMT

Hi,

Have a look at Qlik Function "Not Exist", help on the below:

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFunctions/Exists.htm

There are other methods which you can possibly achieve your requirement such using using joins or mapping flags.

If you have a sample data, you can post it so the community might be able to help you much quicker.

Regards,

Re: How to delete a particular data in a QVD

shakthii — Fri, 23 Aug 2019 10:25:38 GMT

Hi Jpenuliar,

Thanks for the link. Lets say I have a QVD which is updated by a delta FTP file everyday. This file has data of many orders and related ones. One order which was already moved to QVD has been cancelled in the source and the data is still available in the QVD which is wrong. Hope the scenario is clear.

Now, my user is asking if we can delete that particular order which has been cancelled in the source. It will be really helpful if there is any sample code that could be shared.

Re: How to delete a particular data in a QVD

jpenuliar — Fri, 23 Aug 2019 12:49:16 GMT

Hi Shaktii,

assuming you have a file called Order.qvd and "Order1" (value) is already cancelled OrderID (field)

you can do

Load ... From Order.qvd where OrderID <> 'Order1';

Store table...;