Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to have Load Script that first checks to see if the qvd exists and/or has any rows in it.
If it doesn't, then perform a full load.
If it does, it would skip ahead to load a shorter timeframe to add.
I've tried a few versions, but I keep getting zero rows back in my qvd.
Any suggestions?
you try something like below:
if FileSize('lib://Reports/PBAData.qvd')>0 THEN
PBAData:
Load
*
FROM [lib://Reports/PBAData.qvd] (qvd);
MaxTable:
Load max("WorkflowID") as MaxID
Resident PBAData;
Let MAXID = num(peek('MaxID',0,MaxTable));
drop table MaxTable;
LIB CONNECT TO 'Original_database';
Concatenate(PBAData)
//NewRecordData
SQL SELECT WorkflowID,
ActiveID,
Activitynumber
FROM Knowdatabase.workflowtable where
workflowid > $(MAXID);
STORE PBAData into 'lib://FC_KYC_Reports/PBAData.qvd' (qvd);
Else
LIB CONNECT TO 'Original_database';
PBAData:
SQL SELECT WorkflowID,
ActiveID,
Activitynumber
FROM Knowdatabase.workflowtable;
Store PBAData into 'lib://FC_KYC_Reports/PBAData.qvd' (qvd);
End IF
Hello,
you can use QvdNoOfRecords function.
Exemple :
If QvdNoOfRecords('lib://folder/file.qvd')>0 then
//partial load
else
//full load
endif
as suggested by @Pierrick ,you can use QvdNoOfRecords or QvdCreateTime or FileSize functions in load script to check QVD is present or not.....