loading qvds

[prabhas277]

Hi Experts,

I have monthly qvds like jan,feb,... Dec now my requirement is if i load 7th month qvd then at the same i want load previous month last day qvd i.e 6th month 30 th or 31 th qvd. how can get it?

[ecolomer]

Can you explain more details, please?

[prabhas277]

Hi,

I have monthly Qvds like jan,fed,march,apr,....dec. The monthly qvd having all day qvds like 1st,2nd,3rd...31st day qvds. now my requirement is i want  load 5 th month Qvd and same time i want load previous month last day qvd i.e 4th month 31 st day qvd. how can achive it?

[ecolomer]

but that means having a qvd for each day or one for each month with a record for each day?

[Anonymous]

hi prabhas,

Maybe try:

Let vMinMonth = AddMonths(MonthEnd(Today()),-1);

For Each vFile in FileList('...\...\Data*.qvd')

  Let vBaseFilename = Substring(vFile, '\', -1);

  Let vDate = Date#(Mid(vBaseFilename, 6, 6));

  If vDate >= vMinMonth Then

       Data:

       LOAD *

       FROM [$(vFile)] (qvd);

  End If

Next

Regards

Neetha