topic Daily qvd files from ODBC in App Development https://community.qlik.com/t5/App-Development/Daily-qvd-files-from-ODBC/m-p/1454092#M35693 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have been searching these forums and others but have not been able to find what I'm looking for.</P><P>Basically, I have a transactions DB and I want to extract and store data into daily qvd files. (one qvd per transaction date).</P><P></P><P>I know how to connect to the DB. I know how to store a table into a qvd. What i dont know is how to loop through the DB and save a seperate qvd for each transaction date.</P><P></P><P>I need to create a daily qvd file for each day from the last two years so the solution will need to loop through the DB table saving each days transactions under a seperate qvd.</P><P></P><P>Any help would be greatly appreciated.</P><P></P><P>Regards,</P><P>Peter.</P></BODY></HTML> Thu, 11 Jan 2018 13:40:21 GMT pgardner5295 2018-01-11T13:40:21Z Daily qvd files from ODBC https://community.qlik.com/t5/App-Development/Daily-qvd-files-from-ODBC/m-p/1454092#M35693 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have been searching these forums and others but have not been able to find what I'm looking for.</P><P>Basically, I have a transactions DB and I want to extract and store data into daily qvd files. (one qvd per transaction date).</P><P></P><P>I know how to connect to the DB. I know how to store a table into a qvd. What i dont know is how to loop through the DB and save a seperate qvd for each transaction date.</P><P></P><P>I need to create a daily qvd file for each day from the last two years so the solution will need to loop through the DB table saving each days transactions under a seperate qvd.</P><P></P><P>Any help would be greatly appreciated.</P><P></P><P>Regards,</P><P>Peter.</P></BODY></HTML> Thu, 11 Jan 2018 13:40:21 GMT https://community.qlik.com/t5/App-Development/Daily-qvd-files-from-ODBC/m-p/1454092#M35693 pgardner5295 2018-01-11T13:40:21Z