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?
File that you loading from and storing to might be not the same.
Hi,
Pls change path C:\Documents and Settings\sachin GALAXYHO\Desktop\samples\Potential.qvd;
instead of
store Potential into C:\Documents and Settings\sachin.GALAXYHO\Desktop\samples\Potential.qvd;
Dont put " . " in folder name .
Hope it will help u
regards-bika
Hi Bika,
It is not working,
It is a path which is directly coming after loading table from the potential excel file.
regards-hitesh
see the attached file
simply you try to change the path E:\ update.qvd;
then see the result where you wrong
HI,
If you want to update your QVD, then you have to load it first.
In your example, the script will be:
Potential:
LOAD
Number
FROM
Potential.qvd(qvd)
;
LOAD
Number
FROM
potential.xlsx
(ooxml, embedded labels, table is Sheet1)
Where
not exists (Number,Number);
store Potential into C:\Documents and Settings\sachin.GALAXYHO\Desktop\samples\Potential.qvd;
Hi Mohit,
I am using personal edition so plz copy the code in word file and attach.
thanks and regards,
Hittesh.
TRY ACCORDING TO THIS--
POTENTIAL_QVD:
LOAD * INLINE [
id,name
1, dddk
2,cck
];
join
POTENTIAL_EXCEL:
LOAD * INLINE [
id,name
1, dk
2,cck
3,ab
4,cd
]Where not Exists(id);
STORE POTENTIAL_QVD into D:\POTENTIAL_QVD
*****************************************************************************
or try this
POTENTIAL_QVD_test:
LOAD * INLINE [
id_test,name_test
1, dddk
2,cck
];
Right Join
POTENTIAL_EXCEL_test:
LOAD * INLINE [
id_test,name_test
1, dk
2,cck
3,ab
4,cd
];
STORE POTENTIAL_QVD into D:\POTENTIAL_QVD
sorry for late reply
script is
a:
LOAD product_id ,
p_value
FROM
(ooxml, embedded labels, table is Sheet1);
Concatenate (a)
LOAD product_id ,
p_value
FROM
(ooxml, embedded labels, table is Sheet2)
Where not Exists (product_id);
STORE a into E:\Update.qvd;
Hi,
One reason could be, you dont have the right to write into file.
Kindly look into the windows file security.
Also try deleting the QVD and regenerate it with diff name.
Regards,
Kaushik Solanki