Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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...