Load and save QVD

[#1]

How to load a QVD file and append the new data to it and save it back to its original name

[sivarajs]

create a qvd

set qvdpath=c:\file.qvd;

Tmp:

load *

from $(qvdpath);

concatenate

load fields //new data

from file.xls;

store Tmp into $(qvdpath)(qvd);

[#3]

i tried it, but it says could not find table Tmp

[kaushiknsolanki]

Hi,

    We call this as incremental load.

    Have a look at the below links for documentation on incremental load

    http://community.qlik.com/docs/DOC-1870

Regards,

Kaushik Solanki

[#5]

Thanks kaushik, my case happens similar to scenario 6 as said in your dcoument. there step 5 says "Save Updated Data". i need clarification on that. i get the updated data in the report once i click the reload(say value1 changes to value2), but if i click for reload for the second time the data is rolled back(values2 changes back to value1). Same wit insert, the inserted row disappears.

[#6]

New_Table:

SELECT ID from DB_Table where date>$(lastexedate);

Temp:

Concatenate(New_Table)

LOAD ID

     FROM

File.Qvd

(qvd)

WHERE NOT EXISTS (ID);

Inner Join SQL SELECT ID FROM DB_Table;

Store Temp into File.Qvd;

Correct me if i am wrong..

[kaushiknsolanki]

Hi,

   Will you please share with us the script which you are using.

Regards,

Kaushik Solanki

[#8]

New_Table:

SELECT ID from DB_Table where date>$(lastexedate);

Concatenate(New_Table)

LOAD ID

FROM

File.Qvd

(qvd)

WHERE NOT EXISTS (ID);

Inner Join SQL SELECT ID FROM DB_Table;

This is the one i am using. i observe that the QVD file is not saved with the changes. Hence, the evaluation happens with the data that was available during the creation of QVD.

[#9 · Accepted solution]

Hi,

     What do you mean by "the evaluation happens with the data that was available during the creation of QVD"? If you want to save it. You can use this:

New_Table:

SELECT ID from DB_Table where date>$(lastexedate);

Concatenate(New_Table)

LOAD ID

FROM

File.Qvd

(qvd)

WHERE NOT EXISTS (ID);

Inner Join SQL SELECT ID FROM DB_Table;

store New_Table into File.qvd(qvd);

Regards,

Xue Bin

[#10]

Thanks Xue Bin. It Worked