How to delete a particular data in a QVD

[shakthii]

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.

[jpenuliar]

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/InterRecordFun...

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,

JP

[shakthii]

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.

[jpenuliar]

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...;