How to update a QVD file?

[#1]

Hi Everyone,

Please help me regarding updating QVD file.

Potential:

LOAD Number

FROM

potential.xlsx

(ooxml, embedded labels, table is Sheet1)

where not exists(Number);

Concatenate

load Number from Potential.qvd(qvd)

where not Exists(Number);

store Potential into C:\Documents and Settings\sachin.GALAXYHO\Desktop\samples\Potential.qvd;

I have changed a value in Numer column ie i have updated value 1 to 11111 in number column in my excel file.
Now when i use above code then it gives me error"execution failed"

please tell me how do i update my QVD file?

[#2]

Hi mohit i have tried with your sol but still it is not working.

see i have qvd file having one column 'Number' which has ' 1,2,3,------10' field no...

now i have updated my excel file ... i changed 1 to 11111....

i am using foll script as per your sol...

a:

LOAD Number

FROM

potential.xlsx

(ooxml, embedded labels, table is Sheet1);

concatenate(a)

LOAD Number From Potential.qvd(qvd)

where not Exists(Number);

store a into C:\Documents and Settings\sachin.GALAXYHO\Desktop\samples\Potential.qvd;

but using this it is concatenating both...

i get a list "1,2,3,---------,10,11111"

where it is not droping the qvd content...