WHen i am using following code : Following error is there:
My data is in excel sheet which is on local desktop.
Directory;
LOAD Id,
StartDate,
EndDate,
Country,
Type,
Sub_Type,
Name,
Killed,
Injured,
Year
FROM
[Copy of Disaster.xlsx]
(ooxml, embedded labels, table is Disaster);
STORE Disaster into C:\Users\nikhil.garg\Desktop\disaster1.qvd ;
//Connect to odbc and incremental load :
ODBC CONNECT32 TO [Excel Files;DBQ=C:\Users\nikhil.garg\Desktop\Disaster_Data\Copy of Disaster.xlsx] (XUserId is dAHCfQRMNLacWZA, XPassword is QDdXaQRMNLacGMA);
SQL SELECT * FROM `C:\Users\nikhil.garg\Desktop\Disaster_Data\Copy of Disaster.xlsx`.`Disaster$`
WHERE ModificationTime >= #$(LastExecTime)#;
Concatenate
LOAD Id,
StartDate,
EndDate,
Country,
Type,
Sub_Type,
Name,
Killed,
Injured,
Year
FROM
disaster1.qvd
(qvd) WHERE NOT Exists(Id);
STORE Disaster INTO C:\Users\nikhil.garg\Desktop\disaster1.qvd;