I am having a problem in creating qvd.
I initially created qvd and opened it with notepad.
Now whatever qvd i am creating it is by default in notepad form. So , Kindly help me What to do because may be qlikview not able to read qvd in notepad form.
HEy please solve my this issue also.
I am having problem in incremental load.
I am using excel sheet dummy data stored on desktop. I created qvd file. Now i updated data and want incremental load. I have used following code. Please help me what to do :
[Copy of Disaster.xlsx]
(ooxml, embedded labels, table is Disaster);
STORE Disaster into C:\Users\nikhil.garg\Desktop\disaster1.qvd ;
// Incremental load :
SQL SELECT Id, StartDate, EndDate, Country, Type, Sub_Type, Name, Killed, Injured, Year FROM 'C:\Users\nikhil.garg\Desktop\Disaster_Data\[Copy of Disaster.xlsx]'
WHERE ModificationTime >= #$(LastExecTime)#;
LOAD Id, StartDate, EndDate, Country, Type, Sub_Type, Name, Killed, Injured, Year FROM C:\Users\nikhil.garg\Desktop\disaster1.qvd
WHERE NOT Exists[Id];
STORE Disaster INTO C:\Users\nikhil.garg\Desktop\disaster1.qvd;
in case of Incremental load.
first you need to load the full load and store that table into a Qvd file.
Then comment out the full load.
and perform the incremental load with the where condition and concatenate the full load table which you stored into the Qvd file with where exist condition.
if possible share the sample file
I think you are not using the correct connection string thats why its gving you ODBC Connection failed...
Please check your connection string and the DSN which you are using..