topic incremental load in QlikView https://community.qlik.com/t5/QlikView/incremental-load/m-p/328216#M707030 <HTML><HEAD></HEAD><BODY><P>Consider using Qlikview Components (Qvc).</P><P><A href="http://qlikviewnotes.blogspot.com/2012/01/incremental-load-using-qlikview.html">http://qlikviewnotes.blogspot.com/2012/01/incremental-load-using-qlikview.html</A></P><P></P><P>You'll have to create a new PK field by concatenating SalesDocId &amp; Line.</P><P></P><P>-Rob</P></BODY></HTML> Wed, 29 Feb 2012 15:35:41 GMT rwunderlich 2012-02-29T15:35:41Z incremental load https://community.qlik.com/t5/QlikView/incremental-load/m-p/328214#M707028 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">hello</SPAN></P><P style="text-align: -webkit-auto;"><SPAN style="font-size: 15px; font-family: arial, sans-serif;"><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><BR /></SPAN></P><P><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">I loaded</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">a table</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">containing</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">the rows</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">of a</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">sales document</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">,</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">SalesDetails</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">whose</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">unique key</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">is formed</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">by two</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">fields</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">:</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">SaleDocId</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">and Line.</SPAN></P><P><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">in this table can</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">be</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">inserted</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">rows</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">.</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">The</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">old lines</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">may</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">be edited</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">or deleted</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">.</SPAN></P><P><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">to increase</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">the speed of loading</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">,</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">I would like to</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">load only the</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">rows to insert</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">,</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">modify or</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">delete.</SPAN></P><P><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">could you please</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">provide me</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">a detailed example of</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">why</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">I am not clear</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">how to do</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">?</SPAN></P><P><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">I imagine</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">that the procedure can</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">be</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">applied</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">to each</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;"> </SPAN><SPAN class="hps" style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">load</SPAN><SPAN style="font-family: arial, sans-serif; font-size: 15px; text-align: -webkit-auto; background-color: #f5f5f5;">.</SPAN></P></BODY></HTML> Wed, 29 Feb 2012 14:31:17 GMT https://community.qlik.com/t5/QlikView/incremental-load/m-p/328214#M707028 francofiorillo 2012-02-29T14:31:17Z incremental load https://community.qlik.com/t5/QlikView/incremental-load/m-p/328215#M707029 <HTML><HEAD></HEAD><BODY><P>Try giving this a read and see if it helps <A href="http://www.qlikviewaddict.com/2012/02/incremental-builds-real-world.html">http://www.qlikviewaddict.com/2012/02/incremental-builds-real-world.html</A></P></BODY></HTML> Wed, 29 Feb 2012 15:10:34 GMT https://community.qlik.com/t5/QlikView/incremental-load/m-p/328215#M707029 2012-02-29T15:10:34Z incremental load https://community.qlik.com/t5/QlikView/incremental-load/m-p/328216#M707030 <HTML><HEAD></HEAD><BODY><P>Consider using Qlikview Components (Qvc).</P><P><A href="http://qlikviewnotes.blogspot.com/2012/01/incremental-load-using-qlikview.html">http://qlikviewnotes.blogspot.com/2012/01/incremental-load-using-qlikview.html</A></P><P></P><P>You'll have to create a new PK field by concatenating SalesDocId &amp; Line.</P><P></P><P>-Rob</P></BODY></HTML> Wed, 29 Feb 2012 15:35:41 GMT https://community.qlik.com/t5/QlikView/incremental-load/m-p/328216#M707030 rwunderlich 2012-02-29T15:35:41Z Re: incremental load https://community.qlik.com/t5/QlikView/incremental-load/m-p/328217#M707031 <HTML><HEAD></HEAD><BODY><P>many thanks.</P></BODY></HTML> Wed, 29 Feb 2012 15:53:13 GMT https://community.qlik.com/t5/QlikView/incremental-load/m-p/328217#M707031 francofiorillo 2012-02-29T15:53:13Z