How to delete a specific row from the qvd without the 'where' clause?

[#1]

Hi,

I have a qvd file in which I want to delete some specific row without the using of 'where' clause. Because if I use the where clause that time I have to load the full data I did not want that.

Thanking You

Regards

Anup

[terezagr]

Would incremental load help?

http://www.quickintelligence.co.uk/qlikview-incremental-load/

[#3]

Thanks Alessandro & Marcus for your reply. Actually I get 60 month of data after every month in this new data some rows are new , some rows are new information for the previous date. In that case I just want to identify those old data from the old qvd and delete those rows from the old qvd then I have to insert the New row and along with insert the new row for the previous date.

Marcus what you are said in that case every month I have to load the full data but it's not required I just want to identify the old modified row delete those row from the old qvd after that concate the old & new row into a old qvd.

Regards

Anup

[marcus_malinow]

Anup,

if you want to avoid loading your full data set, you might want to store QVDs broken down by year / month.

After loading from your SQL data source, use a RESIDENT load on that data to get a table of distinct Year / Month combinations. Then loop through this table, retrieve from your existing Fact table, and the relevant QVD, and store back to the QVD.

When loading the QVDs into your front end, just load the 60 QVD's with the highest Year / Months.

Marcus

Attached is some pseudo code to point you in the right direction.