topic Re: incremental load in QlikView https://community.qlik.com/t5/QlikView/incremental-load/m-p/478584#M178796 <HTML><HEAD></HEAD><BODY><P>Extract into QVD's only the changes from the db, not all the transactions.</P><P></P><P>You use a field that contains the timestamp of the last change. If you don't have one, you decide which transactions needs to be extracted. For example, there is no point in getting the previous years, you will always have the same transactions. </P></BODY></HTML> Sun, 14 Jul 2013 20:39:59 GMT luciancotea 2013-07-14T20:39:59Z incremental load https://community.qlik.com/t5/QlikView/incremental-load/m-p/478583#M178795 <HTML><HEAD></HEAD><BODY><P>What is mean by the incremental load .Could you pls Explain me Briefly </P><P></P><P></P><P></P><P></P><P>Thanks in Advance </P><P></P><P></P><P></P><P>Regards </P><P></P><P></P><P>Raviteja </P></BODY></HTML> Sun, 14 Jul 2013 18:53:47 GMT https://community.qlik.com/t5/QlikView/incremental-load/m-p/478583#M178795 2013-07-14T18:53:47Z Re: incremental load https://community.qlik.com/t5/QlikView/incremental-load/m-p/478584#M178796 <HTML><HEAD></HEAD><BODY><P>Extract into QVD's only the changes from the db, not all the transactions.</P><P></P><P>You use a field that contains the timestamp of the last change. If you don't have one, you decide which transactions needs to be extracted. For example, there is no point in getting the previous years, you will always have the same transactions. </P></BODY></HTML> Sun, 14 Jul 2013 20:39:59 GMT https://community.qlik.com/t5/QlikView/incremental-load/m-p/478584#M178796 luciancotea 2013-07-14T20:39:59Z Re: incremental load https://community.qlik.com/t5/QlikView/incremental-load/m-p/478585#M178797 <HTML><HEAD></HEAD><BODY><P>In the reference manual, this is IMHO quite well explained. Search for chapter 'Using QVD files for incremental load'.</P><P>I think it's chapter 28.4</P></BODY></HTML> Sun, 14 Jul 2013 20:40:26 GMT https://community.qlik.com/t5/QlikView/incremental-load/m-p/478585#M178797 swuehl 2013-07-14T20:40:26Z Re: incremental load https://community.qlik.com/t5/QlikView/incremental-load/m-p/478586#M178798 <HTML><HEAD></HEAD><BODY><P>1. Stored the previous load as a qvd</P><P>2. Load the previous qvd</P><P>3. Get max date from previous qvd</P><P>4. Load the new data (csv file) where date is greater than max date from previous loaded qvd file.</P></BODY></HTML> Mon, 15 Jul 2013 04:02:57 GMT https://community.qlik.com/t5/QlikView/incremental-load/m-p/478586#M178798 NavinReddy 2013-07-15T04:02:57Z