Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
I am a beginner in QlikView. Currecntly i am facing a problem to creating QVDs and Store into hard drive for future use. I am using this sample codes for all tables:
I am using just 35 tables.
let qvdpath='E:\path...................................................\';
store *from TableName1 into $(qvdpath) TableNm1.qvd;
error i am getting...
"Execution of script failed. Reload the old data?"
Let me know any alternative methods.
Thanks in advance.
Roy
Hi Roy
This is what works for me:
LET qvdpath= 'E:\path\';
STORE TableName1 into '$(qvdpath)TableNm1.qvd' (qvd);
Hi ,
Kindly use the below line to set the path.
set qvdpath='E:\path...................................................\';
Thanks,
D J
Hi
Try by replacing the qvdpath var in store statement with the actual path. If it works then use what dhiraj has suggested.
Regards
Bhupesh
Erik
I know my script having no error but it will work only for creating single qvd. I am having 35(min) tables in that qvw, I need to create 13 qvd in single re-load.(TableNm1 to TableNm13),
Please let me know some alternative methods.
Seems its not reloading successfully.
Thanks in Advance.
may be windows permission problem; check that the user / process running the QlikView has the write permission on the path specified/p>
Hi,
Try this
Store TableName1 into $(qvdpath)TableNm1.qvd;
If not working check whether the path exists or you have access to this folder.
Regards,
Jagan.
Hi Biplab Roy,
why do you bother with a variable at all for a task as simple as creating a qvd file?
We have lots of those in our company-wide rollout - in a three-tier architecture - and I have a few in my apps to abuse QlikView for creating a history...
We have the "use relative paths" box checked and just written it out every time and we have no problems.
Also, it might be that your Server (I assume you have that app running on a server) cannot use the drive-letter E? That was my issue for some time.
HTH
Best regards,
DataNibbler
Hi
This error usually occurs because the write operation fails - possible causes are:
Regards
Jonathan
Make a loop for the different file names
for j=1 to 13
LET qvdpath= 'E:\path\';
STORE TableName$(j) into '$(qvdpath)TableNm$(j).qvd' (qvd)
next j
Make sure the export works for one file before adding the loop.