topic Automate process to Create Monthly QVD in App Development https://community.qlik.com/t5/App-Development/Automate-process-to-Create-Monthly-QVD/m-p/1818013#M67020 <P>Hello All,</P><P>&nbsp;</P><P>I am brining huge mount of data from SQL server from 3/9/2020 to today</P><P>example:</P><P>load*;</P><P>sql</P><P>select X , Y, Z</P><P>from Table1;</P><P>&nbsp;</P><P>I want to create monthly QVD while loading the data like&nbsp;</P><P>Table1.Mar2020QVD</P><P>Table1.Apr2020QVD</P><P>.</P><P>.</P><P>.</P><P>.</P><P>Table1.June252020QVD</P><P>&nbsp;</P><P>Can anyone please help me with the code?</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 30 Nov 2021 18:17:33 GMT Qlikuser225 2021-11-30T18:17:33Z Automate process to Create Monthly QVD https://community.qlik.com/t5/App-Development/Automate-process-to-Create-Monthly-QVD/m-p/1818013#M67020 <P>Hello All,</P><P>&nbsp;</P><P>I am brining huge mount of data from SQL server from 3/9/2020 to today</P><P>example:</P><P>load*;</P><P>sql</P><P>select X , Y, Z</P><P>from Table1;</P><P>&nbsp;</P><P>I want to create monthly QVD while loading the data like&nbsp;</P><P>Table1.Mar2020QVD</P><P>Table1.Apr2020QVD</P><P>.</P><P>.</P><P>.</P><P>.</P><P>Table1.June252020QVD</P><P>&nbsp;</P><P>Can anyone please help me with the code?</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 30 Nov 2021 18:17:33 GMT https://community.qlik.com/t5/App-Development/Automate-process-to-Create-Monthly-QVD/m-p/1818013#M67020 Qlikuser225 2021-11-30T18:17:33Z Re: Automate process to Create Monthly QVD https://community.qlik.com/t5/App-Development/Automate-process-to-Create-Monthly-QVD/m-p/1818053#M67028 <P>Hi, there are different posts with possible solutions:</P><P><A href="https://community.qlik.com/t5/QlikView-App-Dev/How-to-create-monthly-QVD/td-p/1160685" target="_blank">https://community.qlik.com/t5/QlikView-App-Dev/How-to-create-monthly-QVD/td-p/1160685</A></P><P><A href="https://community.qlik.com/t5/QlikView-App-Dev/How-to-create-a-monthly-qvd-based-on-date-field-in-data/m-p/1653582" target="_blank">https://community.qlik.com/t5/QlikView-App-Dev/How-to-create-a-monthly-qvd-based-on-date-field-in-data/m-p/1653582</A></P><P><A href="https://community.qlik.com/t5/QlikView-App-Dev/Create-Monthly-QVD-s/td-p/529646" target="_blank">https://community.qlik.com/t5/QlikView-App-Dev/Create-Monthly-QVD-s/td-p/529646</A></P><P>&nbsp;</P> Sat, 26 Jun 2021 07:35:04 GMT https://community.qlik.com/t5/App-Development/Automate-process-to-Create-Monthly-QVD/m-p/1818053#M67028 rubenmarin 2021-06-26T07:35:04Z