Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
aircode:
FOR i = 0 TO 11
LOAD ADDMONTHS(Start_Date, $(i)) AS Start_Date, Data, Category FROM .... WHERE MONTH(Start_Date) = 3;
NEXT i