Let varTemp=1;
Let varThisExec = Date(Now());
Let varLastExec = date(peek('MaxDate', 0, 'LastUpdatedDate'));
LastUpdatedDate:
Load max(Date("Date of Joining")) as MaxDate
FROM /*lib://QVDs/abc.qvd(qvd);*/ [lib://QVDs/Employee.xls]
(biff, embedded labels, table is Sheet1$);
if ('$(varTemp)'=1) then
Qvd:
LOAD
"First Name",
"Last Name",
"Date of Joining",
Designation,
Location,
Salary,
ID
FROM [lib://QVDs/Employee.xls]
(biff, embedded labels, table is Sheet1$)
Where "Date of Joining" > '$(varLastExec)';
Store Qvd into [lib://QVDs/abc.qvd](qvd);
Let '$(varTemp)'=0;
endif
Temp:
LOAD
"First Name",
"Last Name",
"Date of Joining",
Designation,
Location,
Salary,
ID
FROM [lib://QVDs/Employee.xls]
(biff, embedded labels, table is Sheet1$)
Where "Date of Joining" > '$(varLastExec)';
Concatenate
LOAD
"First Name",
"Last Name",
"Date of Joining",
Designation,
Location,
Salary,
ID
from lib://QVDs/abc.qvd(qvd)
where not Exists(ID);
inner join
Load ID FROM [lib://QVDs/Employee.xls]
(biff, embedded labels, table is Sheet1$);
if ('$(ScriptErrorCount)') = 0 then
Store Temp into [lib://QVDs/abc.qvd](qvd);
Let varLastExec = '$(varThisExec)';
endif
Started loading data
LastUpdatedDate << Sheet1$ Lines fetched: 1 Qvd << Sheet1$ Lines fetched: 15 Qvd << Sheet1$ Lines fetched: 30 Qvd << abc (QVD (row-based) optimized) Lines fetched: 30 Temp << Sheet1$ Lines fetched: 15
The following error occurred:
Table 'Temp' not found
The error occurred here:
Store Temp into [lib://QVDs/abc.qvd](qvd)
Data has not been loaded. Please correct the error and try loading again.
