Load certain data

[vipin_mishra479]

Hi All,

I have load my qvd on daily basis like (A_01/06/2016.qvd, A_02/06/2016.qvd,......) load last 2 month data

and i need to load ony last 28 days qvd how can i load last 28 days Qvd in my qvw file.

[Anonymous]

Hi Vipin,

Try this code:

SET vs_Route = 'YourRoute';

For Each File IN FileList('$(vs_Route)'&'A_??/??/????.qvd')

     FileListAux:

       LOAD Right(FileName('$(File)'),16)        as FileName,

       MakeDate(

           Mid(Right(FileName('$(File)'),16),9,4), //Year

           Mid(Right(FileName('$(File)'),16),6,2), //Month

           Mid(Right(FileName('$(File)'),16),3,2)) /*Day*/ as FileDate

       AutoGenerate 1;

Next File

MaxDate:

LOAD MAX(FileDate) as MaxDate RESIDENT FileListAux;

LET vs_d_MaxDate = DATE(Peek('MaxDate',0,'MaxDate'),'DD/MM/YYYY');

NoConcatenate

FileList:

LOAD * RESIDENT FileListAux WHERE FileDate = '$(vs_d_MaxDate)'-28;

IF NoOfRows('FileList')>0 THEN

    For x=0 to NoOfRows('FileList')-1

        LET vs_File = '$(vs_Route)'&Peek(FileName,$(x),FileList);

        Data:

        LOAD * FROM $(vs_File) (qvd);

    Next

END IF;