topic Incremental Load with different scenarios! in QlikView https://community.qlik.com/t5/QlikView/Incremental-Load-with-different-scenarios/m-p/290363#M1182182 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Can someone please explain with example on how to do Incremental Load for following scenario. Hope it will be helpful for others as well.</P><P></P><P>1. PrimaryKey is there in the table but no Time field.</P><P>2. No PrimaryKey in the table but there is a Time field.</P><P>3. No PrimaryKey and Time field in the table</P><P></P><P>Thanks,</P><P>Attitude</P></BODY></HTML> Thu, 19 Jan 2012 15:08:05 GMT 2012-01-19T15:08:05Z Incremental Load with different scenarios! https://community.qlik.com/t5/QlikView/Incremental-Load-with-different-scenarios/m-p/290363#M1182182 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Can someone please explain with example on how to do Incremental Load for following scenario. Hope it will be helpful for others as well.</P><P></P><P>1. PrimaryKey is there in the table but no Time field.</P><P>2. No PrimaryKey in the table but there is a Time field.</P><P>3. No PrimaryKey and Time field in the table</P><P></P><P>Thanks,</P><P>Attitude</P></BODY></HTML> Thu, 19 Jan 2012 15:08:05 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-with-different-scenarios/m-p/290363#M1182182 2012-01-19T15:08:05Z Re: Incremental Load with different scenarios! https://community.qlik.com/t5/QlikView/Incremental-Load-with-different-scenarios/m-p/290364#M1182183 <HTML><HEAD></HEAD><BODY><P>Can anyone have examples of these type of situations?<BR />I also have file having time field but no primary key....</P></BODY></HTML> Mon, 21 Oct 2013 10:42:25 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-with-different-scenarios/m-p/290364#M1182183 MK_QSL 2013-10-21T10:42:25Z Re: Incremental Load with different scenarios! https://community.qlik.com/t5/QlikView/Incremental-Load-with-different-scenarios/m-p/290365#M1182184 <HTML><HEAD></HEAD><BODY><P>AFAIK, to implement incremental load Primary Key and Timestamp are necessary. In absense of any of them, incremental load can't be implemented in complete(Insert, Update, Delete). However, if it's an<STRONG> 'Append Only'</STRONG> case, can be implemented using a simpler logic.</P></BODY></HTML> Mon, 21 Oct 2013 11:30:41 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-with-different-scenarios/m-p/290365#M1182184 tresB 2013-10-21T11:30:41Z Re: Incremental Load with different scenarios! https://community.qlik.com/t5/QlikView/Incremental-Load-with-different-scenarios/m-p/290366#M1182185 <HTML><HEAD></HEAD><BODY><P>See this blog post: <A href="http://qlikviewnotes.blogspot.nl/2012/01/incremental-load-using-qlikview.html" title="http://qlikviewnotes.blogspot.nl/2012/01/incremental-load-using-qlikview.html">Qlikview Notes: Incremental Load using Qlikview Components</A></P></BODY></HTML> Mon, 21 Oct 2013 11:58:15 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-with-different-scenarios/m-p/290366#M1182185 Gysbert_Wassenaar 2013-10-21T11:58:15Z