Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
You can use the check as you do, but use single quotes around the filename instead
If qvdcreatetime('C:\Users\Deepika\Desktop\Courses\QlikView\QlikView Files') Then