Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've data from 2021 in my main QVD, my requirement is how to store the data into individual monthly QVD's using Date field.
Regards,
V
Hi
I think you can store monthly QVD from your based QVD.
you can try this,
When you load data from your QVD then add Where condition into it and extract month & year based data ,
& store it into QVD.
lly, you have to do for all months
so you will get QVD on Monthly basis.
below is the logic that I have applied on my sample data.
FROM [lib:// Path Location .qvd]
(qvd) where Month(date_field ) = 'Feb' and year( date_field ) = 2019;
Store Table_Name into [lib:// Path Location /Feb_2019.qvd](qvd);
Drop Table Table_Name;
Hope this helps,
help user find answers ! don't forget to mark a solution that work for you and click the like button!