Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
How to store data into QVD's Monthly wise.
Thanks
Once generating the QVD for past data by month, then you have to generate the latest QVD for the new months like below.
Data:
LOAD
*
FROM DataSource
WHERE MonthName(DateFieldName) = MonthName(Today());
LET vMonthname = MonthName(Today());
STORE Data INTO [DATA_$(vMonthname).qvd];
Hope this helps you
Regards,
Jagan.
Hi,
Try this, You can just change your Date / Month Field
DIRECTORY ;
Test:
LOAD MonthName(Date) as MonthYear,*;
LOAD Date('1/1/2015'+IterNo()-1) as Date AutoGenerate 1 While IterNo()<=365;
Check:
Load Distinct Monthname(Date) as Month
Resident Test;
let vCount = NoOfRows('Check');
For i=0 to $(vCount) -1
Let vMonth = Peek('Month',$(i),'Month');
[$(vMonth)]:
Load *,'$(vMonth)' as Month1 Resident Test where MonthName(Date) = '$(vMonth)';
Store [$(vMonth)] into [$(vMonth)].qvd;
Drop table [$(vMonth)];
NEXT
Drop table Check;
Hi,
Check this link, hope it helps you.
storing data into qvd in monthly basis | Qlik Community
Regards,
Jagan.
Once generating the QVD for past data by month, then you have to generate the latest QVD for the new months like below.
Data:
LOAD
*
FROM DataSource
WHERE MonthName(DateFieldName) = MonthName(Today());
LET vMonthname = MonthName(Today());
STORE Data INTO [DATA_$(vMonthname).qvd];
Hope this helps you
Regards,
Jagan.
You can load multiple QVDs using wildcard characters. check below link
chk dis too
Thank You All