if i am using the incremental load for the first time and i don't know whether there is qvd file is present or not. can i use the following script for the update.
Temp:
LOAD
ID,
Name,
Department,
Gender,
`Modified Date`;
SQL SELECT *
FROM Details
where [Modified Date] > $(lastReloadTime);
If qvdcreatetime("C:\Users\Deepika\Desktop\Courses\QlikView\QlikView Files") Then
CONCATENATE (Temp)
LOAD
ID,
Name,
Department,
Gender,
`Modified Date`
FROM qwe.QVD(qvd) where not exist(ID);
ELSE
LOAD ID,
Name,
Department,
Gender,
`Modified Date`;
SQL SELECT *
FROM Details;
END IF
store Temp into qwe.QVD(qvd);
for doing the inserts the below script is working
If qvdcreatetime("C:\Users\Deepika\Desktop\Courses\QlikView\QlikView Files") Then
Details:
LOAD
ID,
Name,
Department,
Gender,
`Modified Date`
FROM TST.QVD(qvd) where not exist(ID);
ELSE
Details:
LOAD ID,
Name,
Department,
Gender,
`Modified Date`;
SQL SELECT *
FROM Details;
END IF
CONCATENATE (Details)
LOAD
ID,
Name,
Department,
Gender,
`Modified Date`;
SQL SELECT *
FROM Details
where [Modified Date] > $(lastReloadTime);
store Details into TST.QVD(qvd);
