Discussion Board for collaboration on QlikView Scripting.
i have a trouble with qlikview. i am trying to create qvd file from tables but some tables get an error.
SQL SELECT *
STORE WH_ACTIVITY INTO WH_ACTIVITY.qvd(qvd);
DROP TABLE WH_ACTIVITY;
is working and qvd is created but
STORE WH_ASSESSMENT INTO WH_ASSESSMENT.qvd(qvd);
DROP TABLE WH_ASSESSMENT;
is not created.
Did i do wrong sth?
Thanks for your replies.
the error is not in the creation of the qvd
the error is in the load data for the seconed table
read the error masege
please check you path setting in qlikview script whether it is set to absolute or relative.
Otherwise there is no problem in your script.
How can I solve it?
Try to load it first and check if its loaded properly or not.
Meaning comment the code for creating QVD.
//STORE WH_ASSESSMENT INTO WH_ASSESSMENT.qvd(qvd);
//DROP TABLE WH_ASSESSMENT;
I tried but again the same error.
Then its not a qlikview error, its an error from your database.
Make sure that you are using the proper table name which is there in your database.