Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Since I have included a piece of code to save my tables in QVD. Every time I reload my Qlikview document I get an error.
Can anyone please assist me with this.
Regards,
Karabo
what about the qvd, is correctly written on the disk or not? Have you the permission to write in the directory?
The QVD is correct anf working fine. I do have permision to write in the directory I saved it in.
Could you please send me a copy of the document to test it?
It is company property, so I can't send you the copy. I'll show you part of the scipt though.
Load ParentPortfolio,
AncestorName,
Order
From
[Data Source\PORTFOLIO_LIST.csv]
(txt; codepage is 1252, embedded labels, delimiter is ',', msg);
store [PORTFOLIO_LIST] into
[..\Data Sources\PORTFOLIO_LIST.qvd];
You have to use Alias for the table you want to store:
AAA:
LOAD A, B
FROM .......
(ooxml, embedded labels, table is Foglio1);
store [AAA] into
It's likely that the directory ..\Data Sources\ does not exist. QV will not create a missing directory but merely throws a "General script error".
-Rob
@Rob, the directory does exist and I do have access to it.
@alex, I'll try using alias table names as you suggested and get back to you.
It did not work, I still get the error. My code now looks like this:
Portfolios:
Load ParentPortfolio,
AncestorName,
Order
From
[Data Source\PORTFOLIO_LIST.csv]
(txt; codepage is 1252, embedded labels, delimiter is ',', msg);
store [Portfolios] into
[..\Data Sources\Portfolios.qvd];
Hi,
take backup old QVD file , then Delete old QVD file from your folder and then Reload your application .
Regards
Perumal A