Loading one QVD multiple time and storing it

[khan_imran]

Hello All,

I have one qvd where I want to filter the data for the month of March irrespective of the year((01-03-2017,01-03-18 ). After filtering the data, I want to repeat the same data for 12 month.

For example, If my closing balance of Apple was 100 for the month March,01-03-2018 then the 100 should come to next 12 months Like 01-04-2018 should have 100 as my opening balance,01-05-2018 should have 100 as my opening balance and so no.

Data:

LOAD * Inline [

Start_Date,Data,Category

01-Mar-17,100, Apple

01-Mar-18,110, Apple

01-Mar-19,200, Apple

];

Kindly help me to achieve this.

Thanks in advance.

Regards,

IK

[prieper]

aircode:

FOR i = 0 TO 11
LOAD ADDMONTHS(Start_Date, $(i))     AS Start_Date, Data, Category FROM .... WHERE MONTH(Start_Date) = 3;

NEXT i