Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to qlikview and i am not able to open the qvd file in the qvw file.
Here is the code which i used in the script of qvd
ODBC CONNECT TO [DOPAG;DBQ=DOPAG];
LOAD *; SQL SELECT * FROM IFSAPP.USER_FINANCE;
I am getting the message as 500 rows fetched
When i am trying to use the qvd file in qvw i am getting error file not found but the user_finance.qvd is present in the location.
USER_FINANCE: LOAD USERID, COMPANY AS COMPANY_ID, DEFAULT_COMPANY FROM D:\IFS\Qlikview\Data\Extracted\01_VIEWS\USER_FINANCE.qvd (qvd)
Error Message :
File not found error
Cannot open file: 'D:\IFS\Qlikview\Data\Extracted\01_VIEWS\USER_FINANCE.qvd'
Hi Surendar, the qvd already exists. 'STORE' is used to create qvds, ie:
ODBC CONNECT TO [DOPAG;DBQ=DOPAG];
TableName:
LOAD *; SQL SELECT * FROM IFSAPP.USER_FINANCE;
STORE TableName into [D:\IFS\Qlikview\Data\Extracted\01_VIEWS\USER_FINANCE.qvd] (qvd);
// This will overwrite the qvd. Chek if already exist before overwriting!
NoConcatenate // to avoid autoconcatenation with last table
USER_FINANCE: LOAD USERID, COMPANY AS COMPANY_ID, DEFAULT_COMPANY FROM D:\IFS\Qlikview\Data\Extracted\01_VIEWS\USER_FINANCE.qvd (qvd)
DROP Table TableName;
You need to Store It