Hi Sai,
Here's what you can do.
I guess you are able to store QVDs separately based on date you extracted.
Once you store all the qvds separately. Store them in one qvd just include the date field in it that you've extracted from files. For Ex A.qvd (this has all the dates in it)
Then extract max date from that QVD and store in a variable. Drop the table. Look at below code.
Temp:
Load distinct Date
From *.qvd;
Store Temp into A.qvd (QVD);
Drop table Temp;
MaxDate:
LOAD max(Date) as MaxDate
FROM A.qvd
(qvd);
Let vMaxDate = Peek('MaxDate',0,'MaxDate');
Drop table MaxDate;
For Delta load you can do the following -
Run throw each file using for loop. Extract date again from the file. Compare it with vMaxDate variable in an if condition, if it's greater, then load that file and store into QVD.
For each vFile in FileList(*.xls);
Let vFileDate = use your code for extracted date ;
if $(vFileDate) > $(vMaxDate) then
File:
Load *, [use your code for date] as Date
From [$(vFile)]
where [use your code for date] > $(vMaxDate)
Store File into File_date.qvd (qvd);
next vFile;
Hopefully this works.
Thanks,
