Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all;
i have a trouble with qlikview. i am trying to create qvd file from tables but some tables get an error.
WH_ACTIVITY:
SQL SELECT *
FROM SEAMDB.WH_ACTIVITY;
STORE WH_ACTIVITY INTO WH_ACTIVITY.qvd(qvd);
DROP TABLE WH_ACTIVITY;
is working and qvd is created but
WH_ASSESSMENT:
SQL SELECT *
FROM SEAMDB.WH_ASSESSMENT;
STORE WH_ASSESSMENT INTO WH_ASSESSMENT.qvd(qvd);
DROP TABLE WH_ASSESSMENT;
is not created.
Did i do wrong sth?
Thanks for your replies.
yeşim
hei
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.
Hi hımm,
How can I solve it?
HI,
Try to load it first and check if its loaded properly or not.
Meaning comment the code for creating QVD.
Like this.
WH_ASSESSMENT:
SQL SELECT *
FROM SEAMDB.WH_ASSESSMENT;
//STORE WH_ASSESSMENT INTO WH_ASSESSMENT.qvd(qvd);
//DROP TABLE WH_ASSESSMENT;
Regards,
Kaushik Solanki
Hey
I tried but again the same error.
HI,
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.
Regards,
Kaushik Solanki