topic Other way for doing Delta load in QlikView

topic Other way for doing Delta load in QlikView https://community.qlik.com/t5/QlikView/Other-way-for-doing-Delta-load/m-p/263431#M1189143 <HTML><HEAD></HEAD><BODY><P>I have sample data for initial and delta data in SAP like this</P><P>1. Initial Data</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 646px; border-collapse: collapse;"><TBODY><TR style="height: 36pt;"><TD class="xl65" height="48" style="border: 0.5pt solid black; width: 23pt; height: 36pt; background-color: #ddd9c3;" width="31">Plant</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 59pt; background-color: #ddd9c3;" width="79">Production   <BR /> Order</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 47pt; background-color: #ddd9c3;" width="62">Production   <BR /> Order Type</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 83pt; background-color: #ddd9c3;" width="111">Production   <BR /> Order Type name</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 41pt; background-color: #ddd9c3;" width="54">Customer</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 47pt; background-color: #ddd9c3;" width="62">Customer   <BR /> Name</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 60pt; background-color: #ddd9c3;" width="80">Complete   <BR /> Date</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 55pt; background-color: #ddd9c3;" width="73">Release   <BR /> Date</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 71pt; background-color: #ddd9c3;" width="94">Work   Order</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033242</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z110</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>OUTER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100001</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust1</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">2/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">21/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07091010-03-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033240</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z110</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>OUTER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100001</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust1</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">6/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">21/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07091010-01-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033241</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z110</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>OUTER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100001</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust1</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">4/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">21/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07091010-02-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033830</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z110</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>OUTER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100003</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust3</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">19/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">28/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07229010-01-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033866</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z110</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>INNER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100002</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust2</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">8/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">28/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07240010-01-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033867</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z120</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>INNER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100002</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust2</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">6/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">28/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07240010-02-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033868</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z120</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>INNER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100002</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust2</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">4/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">28/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07240010-03-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033869</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z120</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>INNER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100002</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust2</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">4/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">28/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07240010-04-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31"><SPAN style="color: #ff6600;">1000</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79"><SPAN style="color: #ff6600;">110000033870</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62"><SPAN style="color: #ff6600;">Z120</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN style="color: #ff6600;"><SPAN>INNER KCE</SPAN></SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54"><SPAN style="color: #ff6600;">100002</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62"><SPAN style="color: #ff6600;">Cust2<SPAN style="mso-spacerun: yes;"> </SPAN></SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80"><SPAN style="color: #ff6600;">4/8/2011</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73"><SPAN style="color: #ff6600;">28/7/2011</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94"><SPAN style="color: #ff6600;">07240010-05-000</SPAN></TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033871</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z120</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>INNER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100002</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust2</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">5/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">28/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07240010-06-000</TD></TR></TBODY></TABLE><P>2. Delta data</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 646px; border-collapse: collapse;"><TBODY><TR style="height: 36pt;"><TD class="xl65" height="48" style="border: 0.5pt solid black; width: 23pt; height: 36pt; background-color: #ddd9c3;" width="31">Plant</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 59pt; background-color: #ddd9c3;" width="79">Production   <BR /> Order</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 47pt; background-color: #ddd9c3;" width="62">Production   <BR /> Order Type</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 83pt; background-color: #ddd9c3;" width="111">Production   <BR /> Order Type name</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 41pt; background-color: #ddd9c3;" width="54">Customer</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 47pt; background-color: #ddd9c3;" width="62">Customer   <BR /> Name</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 60pt; background-color: #ddd9c3;" width="80">Complete   <BR /> Date</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 55pt; background-color: #ddd9c3;" width="73">Release   <BR /> Date</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 71pt; background-color: #ddd9c3;" width="94">Work   Order</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033872</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z120</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>INNER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100002</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust2</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">6/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">30/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07240010-04-000</TD></TR><TR><TD height="25" width="31"><SPAN style="color: #ff6600;">1000</SPAN></TD><TD width="79"><SPAN style="color: #ff6600;">110000033870</SPAN></TD><TD width="62"><SPAN style="color: #ff6600;">Z120</SPAN></TD><TD width="111"><SPAN style="color: #ff6600;">INNER KCE</SPAN></TD><TD width="54"><SPAN style="color: #ff6600;">100002</SPAN></TD><TD width="62"><SPAN style="color: #ff6600;">Cust2 </SPAN></TD><TD style="text-align: center;" width="80"><SPAN style="color: #ff0000;"><STRONG> x</STRONG></SPAN></TD><TD width="73"><SPAN style="color: #ff6600;">28/7/2011</SPAN></TD><TD width="94"><SPAN style="color: #ff6600;">07240010-05-000</SPAN></TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033873</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z120</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>INNER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100004</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust4</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">6/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">29/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07240010-06-000</TD></TR></TBODY></TABLE><P><BR />I try to replace the orange line in initial data with the orange line in delta data and it works <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>In Sap, it has a lot of data if I want to update only one line I think it may take a long time right?<BR />so I want to ask 2 questions ....</P><P>1. how to delete this line in delta data if it has x in Complete date?</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 646px; border-collapse: collapse;"><TBODY><TR><TD height="25" width="31"><SPAN style="color: #ff6600;">1000</SPAN></TD><TD width="79"><SPAN style="color: #ff6600;">110000033870</SPAN></TD><TD width="62"><SPAN style="color: #ff6600;">Z120</SPAN></TD><TD width="111"><SPAN style="color: #ff6600;">INNER KCE</SPAN></TD><TD width="54"><SPAN style="color: #ff6600;">100002</SPAN></TD><TD width="62"><SPAN style="color: #ff6600;">Cust2 </SPAN></TD><TD style="text-align: center;" width="80"><SPAN style="color: #ff0000;"><STRONG> x</STRONG></SPAN></TD><TD width="73"><SPAN style="color: #ff6600;">28/7/2011</SPAN></TD><TD width="94"><SPAN style="color: #ff6600;">07240010-05-000</SPAN></TD></TR></TBODY></TABLE><P><BR />2. how can i replace delta data in other way <IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /></P><P></P><P>Thz so much, very much and too much </P></BODY></HTML> Thu, 15 Sep 2011 03:38:38 GMT 2011-09-15T03:38:38Z Other way for doing Delta load https://community.qlik.com/t5/QlikView/Other-way-for-doing-Delta-load/m-p/263431#M1189143 <HTML><HEAD></HEAD><BODY><P>I have sample data for initial and delta data in SAP like this</P><P>1. Initial Data</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 646px; border-collapse: collapse;"><TBODY><TR style="height: 36pt;"><TD class="xl65" height="48" style="border: 0.5pt solid black; width: 23pt; height: 36pt; background-color: #ddd9c3;" width="31">Plant</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 59pt; background-color: #ddd9c3;" width="79">Production   <BR /> Order</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 47pt; background-color: #ddd9c3;" width="62">Production   <BR /> Order Type</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 83pt; background-color: #ddd9c3;" width="111">Production   <BR /> Order Type name</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 41pt; background-color: #ddd9c3;" width="54">Customer</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 47pt; background-color: #ddd9c3;" width="62">Customer   <BR /> Name</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 60pt; background-color: #ddd9c3;" width="80">Complete   <BR /> Date</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 55pt; background-color: #ddd9c3;" width="73">Release   <BR /> Date</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 71pt; background-color: #ddd9c3;" width="94">Work   Order</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033242</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z110</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>OUTER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100001</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust1</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">2/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">21/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07091010-03-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033240</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z110</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>OUTER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100001</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust1</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">6/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">21/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07091010-01-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033241</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z110</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>OUTER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100001</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust1</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">4/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">21/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07091010-02-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033830</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z110</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>OUTER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100003</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust3</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">19/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">28/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07229010-01-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033866</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z110</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>INNER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100002</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust2</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">8/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">28/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07240010-01-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033867</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z120</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>INNER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100002</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust2</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">6/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">28/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07240010-02-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033868</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z120</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>INNER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100002</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust2</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">4/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">28/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07240010-03-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033869</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z120</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>INNER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100002</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust2</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">4/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">28/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07240010-04-000</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31"><SPAN style="color: #ff6600;">1000</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79"><SPAN style="color: #ff6600;">110000033870</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62"><SPAN style="color: #ff6600;">Z120</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN style="color: #ff6600;"><SPAN>INNER KCE</SPAN></SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54"><SPAN style="color: #ff6600;">100002</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62"><SPAN style="color: #ff6600;">Cust2<SPAN style="mso-spacerun: yes;"> </SPAN></SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80"><SPAN style="color: #ff6600;">4/8/2011</SPAN></TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73"><SPAN style="color: #ff6600;">28/7/2011</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94"><SPAN style="color: #ff6600;">07240010-05-000</SPAN></TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033871</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z120</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>INNER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100002</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust2</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">5/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">28/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07240010-06-000</TD></TR></TBODY></TABLE><P>2. Delta data</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 646px; border-collapse: collapse;"><TBODY><TR style="height: 36pt;"><TD class="xl65" height="48" style="border: 0.5pt solid black; width: 23pt; height: 36pt; background-color: #ddd9c3;" width="31">Plant</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 59pt; background-color: #ddd9c3;" width="79">Production   <BR /> Order</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 47pt; background-color: #ddd9c3;" width="62">Production   <BR /> Order Type</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 83pt; background-color: #ddd9c3;" width="111">Production   <BR /> Order Type name</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 41pt; background-color: #ddd9c3;" width="54">Customer</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 47pt; background-color: #ddd9c3;" width="62">Customer   <BR /> Name</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 60pt; background-color: #ddd9c3;" width="80">Complete   <BR /> Date</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 55pt; background-color: #ddd9c3;" width="73">Release   <BR /> Date</TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; width: 71pt; background-color: #ddd9c3;" width="94">Work   Order</TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033872</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z120</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>INNER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100002</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust2</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">6/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">30/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07240010-04-000</TD></TR><TR><TD height="25" width="31"><SPAN style="color: #ff6600;">1000</SPAN></TD><TD width="79"><SPAN style="color: #ff6600;">110000033870</SPAN></TD><TD width="62"><SPAN style="color: #ff6600;">Z120</SPAN></TD><TD width="111"><SPAN style="color: #ff6600;">INNER KCE</SPAN></TD><TD width="54"><SPAN style="color: #ff6600;">100002</SPAN></TD><TD width="62"><SPAN style="color: #ff6600;">Cust2 </SPAN></TD><TD style="text-align: center;" width="80"><SPAN style="color: #ff0000;"><STRONG> x</STRONG></SPAN></TD><TD width="73"><SPAN style="color: #ff6600;">28/7/2011</SPAN></TD><TD width="94"><SPAN style="color: #ff6600;">07240010-05-000</SPAN></TD></TR><TR style="height: 18.75pt;"><TD class="xl66" height="25" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; width: 23pt; height: 18.75pt; background-color: transparent;" width="31">1000</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 59pt; background-color: transparent;" width="79">110000033873</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Z120</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 83pt; background-color: transparent;" width="111"><SPAN>INNER KCE</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 41pt; background-color: transparent;" width="54">100004</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 47pt; background-color: transparent;" width="62">Cust4</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 60pt; background-color: transparent;" width="80">6/8/2011</TD><TD class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 55pt; background-color: transparent;" width="73">29/7/2011</TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; width: 71pt; background-color: transparent;" width="94">07240010-06-000</TD></TR></TBODY></TABLE><P><BR />I try to replace the orange line in initial data with the orange line in delta data and it works <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>In Sap, it has a lot of data if I want to update only one line I think it may take a long time right?<BR />so I want to ask 2 questions ....</P><P>1. how to delete this line in delta data if it has x in Complete date?</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 646px; border-collapse: collapse;"><TBODY><TR><TD height="25" width="31"><SPAN style="color: #ff6600;">1000</SPAN></TD><TD width="79"><SPAN style="color: #ff6600;">110000033870</SPAN></TD><TD width="62"><SPAN style="color: #ff6600;">Z120</SPAN></TD><TD width="111"><SPAN style="color: #ff6600;">INNER KCE</SPAN></TD><TD width="54"><SPAN style="color: #ff6600;">100002</SPAN></TD><TD width="62"><SPAN style="color: #ff6600;">Cust2 </SPAN></TD><TD style="text-align: center;" width="80"><SPAN style="color: #ff0000;"><STRONG> x</STRONG></SPAN></TD><TD width="73"><SPAN style="color: #ff6600;">28/7/2011</SPAN></TD><TD width="94"><SPAN style="color: #ff6600;">07240010-05-000</SPAN></TD></TR></TBODY></TABLE><P><BR />2. how can i replace delta data in other way <IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /></P><P></P><P>Thz so much, very much and too much </P></BODY></HTML> Thu, 15 Sep 2011 03:38:38 GMT https://community.qlik.com/t5/QlikView/Other-way-for-doing-Delta-load/m-p/263431#M1189143 2011-09-15T03:38:38Z