topic Re: Deleting rows from QVD in QlikView https://community.qlik.com/t5/QlikView/Deleting-rows-from-QVD/m-p/855011#M299730 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>//You can load your Excel file :</P><P></P><P>Load</P><P> ID as IDXL</P><P>From MyExcelFile</P><P>;</P><P></P><P>//Load your QVD</P><P>QVD:</P><P>Load</P><P> *</P><P>From MyQvd</P><P><STRONG>Where not Exist(<SPAN style="font-size: 13.3333330154419px;">IDXL, </SPAN>ID)</STRONG></P><P>;</P><P></P><P>STORE <SPAN style="font-size: 13.3333330154419px;">QVD into <SPAN style="font-size: 13.3333330154419px;">MyQvd;</SPAN></SPAN></P><P></P><P>//I think it's work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 17 Apr 2015 15:29:58 GMT Aurelien_Martinez 2015-04-17T15:29:58Z Deleting rows from QVD https://community.qlik.com/t5/QlikView/Deleting-rows-from-QVD/m-p/855010#M299729 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a QVD which contains 3 fields.</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="192"><TBODY><TR><TD class="xl63" height="20" width="64">ID</TD><TD class="xl63" style="border-left: none;" width="64">Name</TD><TD class="xl63" style="border-left: none;" width="64">Age</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">1</TD><TD class="xl64" style="border-top: none; border-left: none;">AAA</TD><TD class="xl64" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">2</TD><TD class="xl64" style="border-top: none; border-left: none;">BBB</TD><TD class="xl64" style="border-top: none; border-left: none;">20</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">3</TD><TD class="xl64" style="border-top: none; border-left: none;">CCC</TD><TD class="xl64" style="border-top: none; border-left: none;">30</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">4</TD><TD class="xl64" style="border-top: none; border-left: none;">DDD</TD><TD class="xl64" style="border-top: none; border-left: none;">40</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">5</TD><TD class="xl64" style="border-top: none; border-left: none;">EEE</TD><TD class="xl64" style="border-top: none; border-left: none;">50</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">6</TD><TD class="xl64" style="border-top: none; border-left: none;">FFF</TD><TD class="xl64" style="border-top: none; border-left: none;">60</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">7</TD><TD class="xl64" style="border-top: none; border-left: none;">GGG</TD><TD class="xl64" style="border-top: none; border-left: none;">70</TD></TR></TBODY></TABLE><P></P><P></P><P>I have and excel which contains ID.Now i need to delete all the ID's from my QVD which are there in excel.</P><P></P><P>Excel:&nbsp;&nbsp; </P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="64"><TBODY><TR><TD class="xl65" height="20" width="64">ID</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">2</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">3</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">4</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">5</TD></TR></TBODY></TABLE><P></P><P>Final data in QVD should be only 2 entries (ID= 6,7).</P><P></P><P>Regards</P><P>Roopesh</P></BODY></HTML> Fri, 17 Apr 2015 09:39:59 GMT https://community.qlik.com/t5/QlikView/Deleting-rows-from-QVD/m-p/855010#M299729 2015-04-17T09:39:59Z Re: Deleting rows from QVD https://community.qlik.com/t5/QlikView/Deleting-rows-from-QVD/m-p/855011#M299730 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>//You can load your Excel file :</P><P></P><P>Load</P><P> ID as IDXL</P><P>From MyExcelFile</P><P>;</P><P></P><P>//Load your QVD</P><P>QVD:</P><P>Load</P><P> *</P><P>From MyQvd</P><P><STRONG>Where not Exist(<SPAN style="font-size: 13.3333330154419px;">IDXL, </SPAN>ID)</STRONG></P><P>;</P><P></P><P>STORE <SPAN style="font-size: 13.3333330154419px;">QVD into <SPAN style="font-size: 13.3333330154419px;">MyQvd;</SPAN></SPAN></P><P></P><P>//I think it's work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 17 Apr 2015 15:29:58 GMT https://community.qlik.com/t5/QlikView/Deleting-rows-from-QVD/m-p/855011#M299730 Aurelien_Martinez 2015-04-17T15:29:58Z