Automate process to Create Monthly QVD

[Qlikuser225]

Hello All,

I am brining huge mount of data from SQL server from 3/9/2020 to today

example:

load*;

sql

select X , Y, Z

from Table1;

I want to create monthly QVD while loading the data like 

Table1.Mar2020QVD

Table1.Apr2020QVD

.

.

.

.

Table1.June252020QVD

Can anyone please help me with the code?

Thanks

[rubenmarin]

Hi, there are different posts with possible solutions:

https://community.qlik.com/t5/QlikView-App-Dev/How-to-create-monthly-QVD/td-p/1160685

https://community.qlik.com/t5/QlikView-App-Dev/How-to-create-a-monthly-qvd-based-on-date-field-in-da...

https://community.qlik.com/t5/QlikView-App-Dev/Create-Monthly-QVD-s/td-p/529646