topic Re: Incremental load to replace last month in QlikView https://community.qlik.com/t5/QlikView/Incremental-load-to-replace-last-month/m-p/620656#M228457 <HTML><HEAD></HEAD><BODY><P>Can anybody help with this?</P></BODY></HTML> Fri, 07 Feb 2014 12:25:33 GMT juleshartley 2014-02-07T12:25:33Z Incremental load to replace last month https://community.qlik.com/t5/QlikView/Incremental-load-to-replace-last-month/m-p/620655#M228456 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>i have built an incremental load that uses the following simple logic:</P><P></P><P>Tbl: Load data from .csv for latest month, create date key '%keyDate'</P><P></P><P>Set vLatestDate = Peek(%keyDate)</P><P></P><P>concatenate (Tbl)</P><P>Load data from historic.qvd where date key <SPAN style="color: #ff0000;">&lt;&gt; vLatestDate</SPAN></P><P></P><P>Where I am struggling is - I would like to replace the &lt;&gt;vLatestDate above with a 'NOT EXISTS' clause so that it can load in an optimized fashion... but I can't get the logic to work!</P><P></P><P>Any help gratefully received! Thanks.</P></BODY></HTML> Fri, 07 Feb 2014 12:00:17 GMT https://community.qlik.com/t5/QlikView/Incremental-load-to-replace-last-month/m-p/620655#M228456 juleshartley 2014-02-07T12:00:17Z Re: Incremental load to replace last month https://community.qlik.com/t5/QlikView/Incremental-load-to-replace-last-month/m-p/620656#M228457 <HTML><HEAD></HEAD><BODY><P>Can anybody help with this?</P></BODY></HTML> Fri, 07 Feb 2014 12:25:33 GMT https://community.qlik.com/t5/QlikView/Incremental-load-to-replace-last-month/m-p/620656#M228457 juleshartley 2014-02-07T12:25:33Z